topic (BLANK) to return 0 for Card Visuals in DAX Commands and Tips

(BLANK) to return 0 for Card Visuals

omd001 — Mon, 01 Mar 2021 06:22:23 GMT

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"))

Re: (BLANK) to return 0 for Card Visuals

AntrikshSharma — Mon, 01 Mar 2021 06:53:51 GMT

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

Re: (BLANK) to return 0 for Card Visuals

omd001 — Sun, 07 Mar 2021 21:54:13 GMT

Thanks so much, AntrikshSharma !!!