Forum Discussion

NikNithiy's avatar
NikNithiy
Helper I
3 years ago

Matrix/Table Visual - Show Blank Values as Zero

Hi Team, I want to just show the blanks as zero in my table/matrix visual. But when i add a zero at the end of measure it is getting drill down and showing unwanted results means the data behind(fil...
Need Help
NikNithiy's avatar
NikNithiy
Helper I
3 years ago

I was not able to dervice this can you please tell me how use the coleasce to this measure "calculate(Tab1[count(id)],filter([tab2],tab2[area]="123"))"

Syk's avatar
Syk
Resident Rockstar
3 years ago
coalesce_measure =
COALESCE (
    CALCULATE ( COUNT ( Tab1[id] ), FILTER ( tab2, tab2[area] = "123" ) ),
    0
)