Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Drag & Drop Scenario
Read the scenario requirements and decide your answer. Click Check Answer below to see the marked solution.
Hotspot Solution:
CALCULATE ALLSELECTED ALLSELECTED: Retains filters that are explicitly set within the query or report (e.g., slicers, filter visuals, report level filters, Dax filters). It removes only the row and column filters that are part of the current context. ALL: Removes all filters, including those explicitly set in the query or report, and resets the context completely. If you use ALLSELECTED, it will espect the report-level filter (only products data).
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Report level doesn't need any other filters; neither All nor AllSelected are needed her All: ignore everything All selected ignores the report level but keeps getting affected by the slicers
ALLSELECTED() non ha senso. ALLSELECTED() dovrebbe stare al numeratore e ALL() al denominatore per avere senso
ok one thing i just feel we need to use allselected cause it says report must respect report level filter , so we need to consider this percentage as for only the products which are slected in report , , guide me if my understanding is wrong