Blank in a multi-row card

[Anonymous]

Hi, 

I have a measure in a multi-row card. 

Average Call Time (Min) = FORMAT(Journal_ab_2018[Average of DurationConnected average per DurationConnected (Min)1]/ 60 / 60 /24;"HH:MM:SS")

I would like to filter these values out when they are blank with the following: 

Average_Time_0 = if(ISBLANK([Average Call Time (Min)]);"0";[Average Call Time (Min)])

But it doesn't seem to do a lot - the blanks remain in the list even when I add the filter 

Any tips?

Thanks.

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Try this one, please.

Average_Time_0 =
IF ( [Average Call Time (Min)] = BLANK (); "0"; [Average Call Time (Min)] )

Best Regards,

[jdbuchanan71]

Can you put an 'is not blank' filter on Average Call Time like you have on CompanyName_Unique?

[Anonymous]

Hi, 

Yeah, I can but it doesn't seem to change anything.