[Solved] Given this DAX expression: UniqueCustomers = DISTINCT(Customer[CustomerID])What will be the result of COUNTROWS(UniqueCustomers) if the Customer table has 100 rows with 80 unique CustomerIDs? | Power BI

Power BI - Data Cleaning with Power Query

Given this DAX expression:
UniqueCustomers = DISTINCT(Customer[CustomerID])
What will be the result of COUNTROWS(UniqueCustomers) if the Customer table has 100 rows with 80 unique CustomerIDs?

A100

B80

C20

D0

Step-by-Step Solution

Solution:

Step 1: Understand DISTINCT output
DISTINCT(Customer[CustomerID]) returns a table with only unique CustomerIDs, so 80 unique rows.
Step 2: COUNTROWS counts rows in the unique table
COUNTROWS(UniqueCustomers) counts these unique rows, which is 80.
Final Answer:
80 unique CustomerIDs counted -> Option B
Quick Check:
COUNTROWS(DISTINCT()) = number of unique rows [OK]

Quick Trick: COUNTROWS(DISTINCT()) counts unique rows [OK]

Common Mistakes:

Counting total rows instead of unique
Confusing difference between DISTINCT and COUNTROWS
Assuming duplicates are counted

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

More Power BI Quizzes

Given this DAX expression:

Step 1: Understand DISTINCT output

Step 2: COUNTROWS counts rows in the unique table

Final Answer:

Quick Check:

Want More Practice?