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
Interactive Drag & Drop Matching
Drag each configuration to its target, or tap an option then tap a target slot.
Hotspot Solution:
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
CALCULATE( DISTINCTCOUNT('Product'[ProductCategory]), 'Sales' )
* Answer: 1. DISTINCTCOUNT ( 'Product'[ProductCategory] ), 2. Sales * Explanation: - DISTINCTCOUNT('Product'[ProductCategory]) → counts unique categories. - 'Sales' → ensures only categories with actual sales are included. - The relationship between Sales → Product ensures that only categories tied to sold products are counted. * Why not the others: - COUNT('Product'[ProductCategory]) → counts rows, not distinct categories. - DISTINCTCOUNT(Sales[ProductID]) → counts products, not categories. - SUM(Sales[SalesQuantity]) → gives total quantity, not number of categories.
Tested. Answer is wrong.Correct answer is : Distinctcount('Product'[product category], 'sales'