Forum Discussion

samuelhoward's avatar
samuelhoward
Frequent Visitor
1 year ago
Solved

Problem with my DAX Count

In my data I have two columns. When I use the following "Count" DAX for either column, I get 8 instead of 4. I think it is counting the number of blanks. How can I go about correcting this?

Superiorcount = count('Table'[Superior])



 

 

I am unable to share my .pbix file as the option on this forum does not seem to exist.



1 Reply

  • samuelhoward's avatar
    samuelhoward
    Frequent Visitor
    The solution is to replace all the blanks with the word "null"