Remove Card/KPI Error

[adityavighne]

Hi team,

I want to remove card/KPI error (cross) instead of that I want blank or zero

[TeigeGao]

Hi @adityavighne ,

Could you please share more information about your problem? Do you delete a measure? 

Best Regards,

Teige

[adityavighne]

No, I haven't deleted measure.

This visual is MoM measure so whenever previous month data is not available so the calculation output I want 0 or blank instead of an error.

[TeigeGao]

Hi @adityavighne ,

Actually, the dateadd() function is a time intelligence function, it rrequires a continous time, you can try to use the IF() function to handle the not available data to zero, for example IF(dateadd(****) = blank() , 0, ***), besides, you will need to create a continous date table which cover the previous date.

Best Regards,

Teige

[adityavighne]

This is my measure - 

1)

[Total Goal Completions] = sum(column 1)+ sum(column 2)

MoM % GC = ([Total Goal Completions])-[GC Prior Period]/[GC Prior Period]

2)

MoM % Clicks = (SUM('PROD PaidMedia'[Clicks])-[Clicks Prior Period])/[Clicks Prior Period]