Matrix/Table Visual - Show Blank Values as Zero

[NikNithiy]

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"))

[Mkarwa-123]

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!

[Syk]

Try using the COALESCE function. This will get the first non-blank value so just pass a 0 as the second argument.

https://learn.microsoft.com/en-us/dax/coalesce-function-dax

[NikNithiy]

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]

coalesce_measure =
COALESCE (
    CALCULATE ( COUNT ( Tab1[id] ), FILTER ( tab2, tab2[area] = "123" ) ),
    0
)