Forum Discussion
samuelhoward
1 year agoFrequent Visitor
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.
- The solution is to replace all the blanks with the word "null"
1 Reply
- samuelhowardFrequent VisitorThe solution is to replace all the blanks with the word "null"