Decimal condition in DAX

[Anonymous]

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!

[kentyler]

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

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

[kentyler]

Is the column a text column or a numeric column ?

[Anonymous]

It's a numeric column.

[kentyler · Accepted solution]

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