Value "0" not recognized in Column.

[UnclePaul]

Hi There,

I have a very annoying issue.  I try to create a calculated column wherein values are appointed to different bins.

I look up if a value in TAT IR is less than 5. If "True" than it should be tagged with the "0-5" category. However all values with a TAT IR with 0 are not recognized. 

TAT IR Column is formated as whole number.  

Any a suggestion what could be the problem ?

many thanks in advance,

[v-yulgu-msft · Accepted solution]

Hi @UnclePaul,

It looks like zero is recognized as Blank(), but different from null value. I cannot either distinguish them well, but you could try below DAX formula:

TAT IR bins2 =
IF (
    NOT ( ISBLANK ( Table2[TAT IR] ) ),
    IF ( Table2[TAT IR] <= 5, "0-5", IF ( Table2[TAT IR] <= 10, "6-10", ">10" ) )
)

Best regards,

Yuliana Gu

[UnclePaul]

Thanks a lot, that did the job.

Still cannot understand why this occurs...a bit strange though..