Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
I have attempted all sugestions but none have worked. Ill leave this thread open if I find a solution I will post about it.
Hey @ReubenS
you can try this one:
=
Var _TOTAL= COUNT([Field1])
RETURN IF(_TOTAL = blank(),0,_TOTAL)
Cheers, LQ
Hi @ReubenS
try this measure,
Measure=if(calculate(count(Field))=Blank(),0,calculate(count(Field))
Thanks and Regards
Thennarasu
@ReubenS , This works best when the color is coming from a separate dimension
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |