Power BI - Data Cleaning with Power Query
Why does the DISTINCT function in DAX sometimes return fewer rows than expected when applied on a column with blank values?
Why does the DISTINCT function in DAX sometimes return fewer rows than expected when applied on a column with blank values?
hard📝 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand how DISTINCT treats blanks
DAX DISTINCT treats all blank (empty) values as a single unique value.Step 2: Effect on row count
Multiple blank rows count as one unique blank, reducing total distinct count.Final Answer:
DISTINCT treats all blank values as one unique value -> Option AQuick Check:
DISTINCT groups all blanks as one unique value [OK]
Quick Trick: DISTINCT groups all blanks as one unique value [OK]
Common Mistakes:
- Thinking blanks are ignored
- Assuming blanks count as multiple unique values
- Expecting errors from blanks
Master "Data Cleaning with Power Query" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes