Problem with my DAX Count

[samuelhoward]

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.

[samuelhoward · Accepted solution]

The solution is to replace all the blanks with the word "null"