Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Chas2002
Helper III
Helper III

Measure: DAX + 0 not returning 0

Hi,

 

Have this measure built, but it's still returning (Blank)?

 

Disposition = 
CALCULATE(
COUNTA('CallRecord'[Final Disposition Of Call]),
'CallRecord'[Final Disposition Of Call] IN {3} 
) + 0

 

As a test I changed + 0 to + 1 and checked, it does show 1 so I know the measure is working, it's just not showing 0 instead of (blank) when no count is returned for Final Disposition= 3.

 

For context: [Final Disposition of Call] is a Whole Number and contains values: 1, or 2, or 3, or 4, or 5, or 6, or 7 and it's never empty/null...

 

What should be my next step?

 

Thanks,

Chas

 

1 ACCEPTED SOLUTION

Hi @Chas2002

 

Thanks - downloade the file.

 

I get exactly the same issue, but only on that particular visual. If I change to a table or other visual, zero displays correctly in the tooltip.

 

As a temporary fix, you could change 0 to any small enough number, for example the smallest possible positive decimal number 2.23E-308

 

So the issue appears to be not the measure itself, but the way that this particular visual displays the measure in the tooltip.

 

Regards,

Owen


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

7 REPLIES 7
OwenAuger
Super User
Super User

Hi Chas,

That's odd, because BLANK () + 0 should always be zero, so can't explain why it's not working in the first place

 

You could try this instead

Disposition =
VAR Disp =
    CALCULATE (
        COUNTA ( 'CallRecord'[Final Disposition Of Call] ),
        'CallRecord'[Final Disposition Of Call] IN { 3 }
    )
RETURN
    IF ( ISBLANK ( Disp ), 0, Disp )

Regards,

Owen


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Hi Owen,

 

I used your measure formula and it still returns (blank)?

 

I must be missing something...

 

disposistion.jpg

Not sure myself...any chance you could post a pbix file, santised if needed?

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Hi Owen,

 

Thanks for your help.

 

You can find the .pbix zip file here: https://www.dropbox.com/s/gl3gdbnqarqrmwb/testPBIX.zip?dl=0

 

Unzip it to: C:\

 

Let me know when you've downloaded it so I can remove.

 

If you hover over Skill Set 4 in the chart, you'll see the (Blank) issue.

 

Chas

 

PS - you may have to copy and paste the link, doesn't seem to work if you click in PwrBI Forums...

Hi @Chas2002

 

Thanks - downloade the file.

 

I get exactly the same issue, but only on that particular visual. If I change to a table or other visual, zero displays correctly in the tooltip.

 

As a temporary fix, you could change 0 to any small enough number, for example the smallest possible positive decimal number 2.23E-308

 

So the issue appears to be not the measure itself, but the way that this particular visual displays the measure in the tooltip.

 

Regards,

Owen


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Hi Owen,

 

Thanks, you're analysis was spot on.  I contacted the company that built the vizulation and they are working to correct it.

 

Thanks again,

Chas

@Chas2002

 

This look like an issue of the custom visual

 

Try using anothe visual to see if the blank still happen

 

Regards

 

Victor




Lima - Peru

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.