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(filters removed) is also adding and showing as zero. but my expectation is to show only the blanks as zero with filters in measure/visuals remains. sample visual is below.

 

when add a zero at end of measure 

 

 This happen in both table and matrix visual have said that my measure as a filter function for ex

calculate(Tab1[count(id)],filter([tab2],tab2[area]="123"))

 

Need Help

4 Replies

    • 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
)
  • Mkarwa-123's avatar
    Mkarwa-123
    Resolver II
    3 years ago

    Hi NikNithiy  On top of your DAX measure you can put a condition
    IF( value = NULL, 0, value)

    Did I answer your question? Mark my post as a solution!