cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brijesh
Frequent Visitor

Value 0 is not being recognized

Hi community, 

I have a simple question regarding a calculated column, a 0 value is not being recognised. I have a calculated column (let's call it a column A), formatted whole number data-type. I'm creating another calculated column (let's call it column B) to find out a status based on value in column A. I'm using a simple if statment as per below;

 
Column B = IF('Table1'[Column A] = BLANK(),BLANK(),
IF('Table1'[Column A] <= 1,"Within SLA","Outside SLA"))

 

There are some blank values in column A, hence, in my condition I'm returnig blank for those but there are some 0 values in column A where it should return "Within SLA" INSTEAD it is returing blank!

 

 
 

I would appreciate your help on this issue.

 

Brijesh

2 ACCEPTED SOLUTIONS
amitchandak
Super User IV
Super User IV

@Brijesh , Try like

 

Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] < 1,"Within SLA","Outside SLA"))

or


Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] <= 1,"Within SLA","Outside SLA"))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

yingyinr
Community Support
Community Support

Hi @Brijesh ,

You can watch the following video to get a good understanding of difference with ISBLANK and BLANK():

BLANK,ISBLANK

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Community Support Team _ Rena
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

3 REPLIES 3
amitchandak
Super User IV
Super User IV

@Brijesh , Try like

 

Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] < 1,"Within SLA","Outside SLA"))

or


Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] <= 1,"Within SLA","Outside SLA"))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Thanks Amit,

 

It worked like charm!! Do you know why it wasn't working when I was comparing blank value rather than ISBLANK function? I mean what's the difference between these two method?

yingyinr
Community Support
Community Support

Hi @Brijesh ,

You can watch the following video to get a good understanding of difference with ISBLANK and BLANK():

BLANK,ISBLANK

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Community Support Team _ Rena
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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.