Forum Discussion

UnclePaul's avatar
UnclePaul
Frequent Visitor
8 years ago
Solved

Value "0" not recognized in Column.

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,

 

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      UnclePaul
      Frequent Visitor
      8 years ago

      Thanks a lot, that did the job.

       

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