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
UnclePaul
Frequent Visitor

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,

 

Issue_PowerBi_Desktop.png

 

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

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" ) )
)

1.PNG2.PNG

 

Best regards,

Yuliana Gu

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

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

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" ) )
)

1.PNG2.PNG

 

Best regards,

Yuliana Gu

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

Thanks a lot, that did the job.

 

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

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.