I want to show 0 instead of blank

[Rockz]

Dear,

I have table visual where ABC and MAN Coulmn have  some blank values so Instaed of blank values i wnat to show 0. how this is possible?

and I'm using these measure for this. 

ABC = CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "A")

MAN = CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "M")

 but if i apply these measures Top 10 is not working.

Could you please help in this! 

Thanks in advance.

[PijushRoy]

Hi @Rockz 

Use below measure

ABC = If(IsBlank(CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "A")),0,CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "A"))

MAN = If(IsBlank(CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "M")),0,CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "M"))

If solve your requirement, please MARK THIS ANSWER AS SOLUTION

[Ahmedx]

ABC =COALESCE(CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "A"),0)

MAN = COALESCE(CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "M"),0)
====

ABC =
VAR _t1 =CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "A")
RETURN IF(_t1,_t1,0)

MAN =
VAR _t1 = CALCULATE(SUM('XYZ'[Order Value ]), 'XYZ'[ABC/MAN] = "M")
RETURN IF(_t1,_t1,0)