Matrix to show "0" instead of blank values for a count

[ReubenS]

I have a matrix with a generic rows of distinct values, in the example I have used colors and then the field created month for the coloumns. I am trying to show in a matrix when there is an empty field I would like it to show "0" ,as its a count instead of nothing.

I have tried :

= COALESCE(COUNT([Field1]), 0)

 measure = IF(ISBLANK(Count[Field1]),0,Count[Field])

measure = Count([Field1]) +0

[ReubenS]

I have attempted all sugestions but none have worked. Ill leave this thread open if I find a solution I will post about it.

[LQuedas]

Hey @ReubenS 

you can try this one:

=

 Var _TOTAL= COUNT([Field1])

RETURN IF(_TOTAL = blank(),0,_TOTAL)

Cheers, LQ

[Thennarasu_R]

Hi @ReubenS 
try this measure,
Measure=if(calculate(count(Field))=Blank(),0,calculate(count(Field))

Thanks and Regards
Thennarasu

[amitchandak]

@ReubenS , This works best when the color is coming from a separate dimension