Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Decimal condition in DAX

‎11-25-2019 08:14 AM

I want to add a condition in dax where [columnname] is either less than 0 or equal to 0 or equal to 0.0 or equal to 0.00.

 

Please suggest!

Labels:
Message 1 of 5
3,869 Views
0
1 ACCEPTED SOLUTION
kentyler
Solution Sage
Solution Sage
In response to Anonymous

‎11-25-2019 09:59 AM

Wrapping it in INT() should have the same effect on a numeric column.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

Message 4 of 5
3,827 Views
4 REPLIES 4
kentyler
Solution Sage
Solution Sage

‎11-25-2019 08:33 AM

The only way you can display a number like 0.0 is if it is in a text column, other wise it will display as 0.

I made a small sample that has the values you are asking about in a text column. I added a calculated column to test if they were greater than zero (1 = true, 0 = false).

In order to do the "greater than" operation I had to use the INT() function to convert the test values to integers
GreaterThanZero_11252019.png

Hope that answers your question. 
I'm a personal Power BI trainer. 





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Message 5 of 5
3,863 Views
kentyler
Solution Sage
Solution Sage

‎11-25-2019 08:21 AM

Is the column a text column or a numeric column ?





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Message 2 of 5
3,865 Views
0
Anonymous
Not applicable
In response to kentyler

‎11-25-2019 09:18 AM

It's a numeric column.

Message 3 of 5
3,856 Views
0
kentyler
Solution Sage
Solution Sage
In response to Anonymous

‎11-25-2019 09:59 AM

Wrapping it in INT() should have the same effect on a numeric column.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Message 4 of 5
3,828 Views

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All