Question 129 of 388
Single answerDrag and Drop QuestionYou have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.
✓ASee source PDF for answer choices.
BAdditional option
✓
Correct Answer: A
See source PDF for answer choices.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.