Forum Discussion

Chas2002's avatar
Chas2002
Helper III
8 years ago
Solved

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...
Need Help
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    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

OwenAuger's avatar
OwenAuger
Super User
8 years ago

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

Chas2002's avatar
Chas2002
Helper III
8 years ago

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