Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

DAX Calculated colum, IF > Statement, returns ties?

Today I had two columns:

1. A calculated unit price column in my Sales table.

2. A related column from our price list, returns retail unit prices


We needed a third column to flag when the price paid was greater than the retail unit price.


3. If(Unit Price > Retail price, "Flag", Blank())


What I got was the price paid that were greater than retail, but also all the instances where Price Paid=Retail??


I had to add $.01 to the retail price in order to break the tie and get the flag filter to work.

Advocate III
Advocate III

Please see attached,  I have gone out to the max of 15 places, and do not see a difference in these two numbers.


Is it possible there is a variance beyond 15 places I can't see limited to 15 places?




Based on my test, the maximum of decimal places in PBI Desktop is 15. If you data source number has more than 15 decimal places, it may be rounded.


Best Regards,





Not sure what are your tables like. I just tested with following two simple tables.

DAX Calculated colum, IF Statement, returns ties_1.jpg


I create a calculated column with following DAX formula.

Column =
IF ( Sales[unit price] > RELATED ( Price[retail unit prices] ), "Flag" )

DAX Calculated colum, IF Statement, returns ties_2.jpg


Best Regards,



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors