[Solved] You wrote this DAX measure to get unique products:UniqueProducts = DISTINCT(Sales[ProductID])But Power BI shows an error. What is the problem? | Power BI

Power BI - Data Cleaning with Power Query

You wrote this DAX measure to get unique products:
UniqueProducts = DISTINCT(Sales[ProductID])
But Power BI shows an error. What is the problem?

AProductID column does not exist

BDISTINCT cannot be used in measures

CDISTINCT returns a table, not a scalar value

DSyntax error: missing parentheses

Step-by-Step Solution

Solution:

Step 1: Understand DISTINCT output type
DISTINCT returns a table of unique values, not a single number or scalar.
Step 2: Measures require scalar values
Measures must return a single value, so using DISTINCT alone causes an error.
Final Answer:
DISTINCT returns a table, not a scalar value -> Option C
Quick Check:
DISTINCT returns table, not scalar [OK]

Quick Trick: DISTINCT returns table; use aggregation for scalar [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You wrote this DAX measure to get unique products: