Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Re: Margin Divisible by 5?

here is my formula and it works fine.  So I have to think something strange is happening to your data column.    Do you have any rougue values somewhere in the column?  Try writing a calc column =Max(table[total cost margin]) and see what you get



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Microsoft v-yulgu-msft

Re: Margin Divisible by 5?

Hi @rynoh17,


Please check the data type of the column [Margin]. If it is text, the formula will return #ERROR and you should change it to decimal number.


Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rynoh17 Member

Re: Margin Divisible by 5?



Sale Prices of $0.00 were creating -infinity values which was screwing it up. I stacked another IF statement on top of the other, saying IF([Sale]=0, IF(MOD([Margin], .05) = 0, "True", "False"), "False")

View solution in original post

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)