If no Data then give "0" is not working.

[Anonymous]

Hi,

I've below measure adding +0 is not working. It it because of CountA  function??

Overview_ActInternal = CALCULATE(COUNTA(Audit[Plan/Act]),Audit[Plan/Act]={"Act"},Audit[Int/Ext]={"Int"},Audit[LastMonthYear]=1)+0

Need help on this. thanks!

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Try wrapping the whole thing in IF(ISBLANK()) for example

Overview_ActInternal = 

VAR Res = CALCULATE(COUNTA(Audit[Plan/Act]),Audit[Plan/Act]={"Act"},Audit[Int/Ext]={"Int"},Audit[LastMonthYear]=1)

RETURN IF(ISBLANK(Res,0,Res))

Regards

Phil

[Anonymous]

Hi,

Thanks for your help!

I did the same but I get all the Dimension values with empty though I selected only one value. 

Pls see the screen shot.