HOTSPOT -
You need to create a measure that returns the percent of revenue by product category.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
 
















 

Suggested Answer: 
    

Box 1: CALCULATE -
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE([,  [,  [, ג€¦]]])
Box 2: REMOVEFILTERS -
REMOVEFILTERS clear filters from the specified tables or columns.
Box 3: DIVIDE -
DIVIDE performs a division.
Example: MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS()))
Note: The RETURN keyword consumes variables defined in previous VAR statements.
Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax

https://docs.microsoft.com/en-us/dax/removefilters-function-dax
 https://dax.guide/st/return/

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.