Microsoft Power BI Data Analyst (PL-300)

What is the difference between DISTINCTCOUNT() and COUNT() in DAX?

COUNT counts blanks; DISTINCTCOUNT does not DISTINCTCOUNT counts unique non-blank values; COUNT counts all non-blank values including duplicates They are identical in behavior COUNT only works on numeric columns; DISTINCTCOUNT works on text

Correct Answer:

DISTINCTCOUNT counts unique non-blank values; COUNT counts all non-blank values including duplicates

Access more questions from this quiz

Continue to Microsoft Power BI Data Analyst (PL-300) for more practice questions and the full quiz experience.

Access More Questions