How should you complete the calculation?

DRAG DROP

You 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.

Answer:

Explanation:

Box 1: CALCULATE

CALCULATE rvaluates an expression in a modified filter context.

Box 2: DIVIDE

As a data modeler, when you write a DAX expression to divide a numerator by a denominator, you can choose to use the DIVIDE function or the divide operator (/ – forward slash).

When using the DIVIDE function, you must pass in numerator and denominator expressions.

Box 3: ALLSELECTED

ALLSELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries.

Example:

measure ‘Reseller Sales'[Reseller Visual Total]=calculate(sum(‘Reseller Sales'[Sales Amount]), ALLSELECTED())

Latest DA-100 Dumps Valid Version with 114 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments