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
)