DAX Calculated colum, IF > Statement, returns ties?

[mwaltercpa]

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.

[mwaltercpa]

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?

[v-haibl-msft]

@mwaltercpa

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,

Herbert

[v-haibl-msft]

@mwaltercpa

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

I create a calculated column with following DAX formula.

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

Best Regards,

Herbert