(BLANK) to return 0 for Card Visuals

[omd001]

Hi,

I am trying to create cards to count the number of projects based on different status.
However, when there are no records for a specific status, DAX is returning (Blank) instead of zero (0).

I have created a measure that counts it, however, I am not certain how to further improve this in a way that it would make the blank results as 0.

Active = COUNTROWS(FILTER('FACT PSR','FACT PSR'[Project: Status] = "Active"))

[AntrikshSharma · Accepted solution]

@omd001 Just add + 0 at the end of the measure.

[omd001]

Thanks so much, @AntrikshSharma !!!