cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Birdwatcher1977 Frequent Visitor
Frequent Visitor

Blank in a multi-row card

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:MMSmiley FrustratedS")
 
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 
PowerBI.JPG
 
Any tips?
 
Thanks.
 
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Blank in a multi-row card

Hi @Birdwatcher1977,

 

Try this one, please.

 

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

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
jdbuchanan71 New Contributor
New Contributor

Re: Blank in a multi-row card

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

Re: Blank in a multi-row card

Hi, 

 

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

Community Support Team
Community Support Team

Re: Blank in a multi-row card

Hi @Birdwatcher1977,

 

Try this one, please.

 

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

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.