Matrix visual: using Count of a field as values to show Zero instead of Blank

[CLTJSDUDE82]

Hi All, 

I looked everywhere and there is no solution, the only proposed idea was shot down (https://ideas.powerbi.com/ideas/idea/?ideaid=b3961b55-09ab-432f-ba1b-0f19bd78931c&page=6)

I have tried the below two formulas and it works for the card visual but not the matrix visual. Has anyone else found a workaround? 

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

and

count plus zero measure = Count [Field1] +0

[CLTJSDUDE82]

Note:  Coalesce fucntion does not work 

= COALESCE(COUNT[Field1]), 0)

[Anonymous]

Hi @CLTJSDUDE82 ,

From the formula, there seems to be nothing wrong, do you have an effect if you put it in table visual? Or is it only matrix that can't be applied?

Best regards,

Community Support Team Selina zhu

[CLTJSDUDE82]

Hi @Anonymous ,

When I convert it into a table (from the matrix) with any of the above measures, those blanks will just not show up as a row. thanks