Dax error

[Diportee97]

Hello guys,i have a problem with my Profit Column,I'm getting negative values and it's messing up my data,and here's how i calculated it; Sales Amount - Unit Cost * Quantity Sold

Please help me out

[Irwan · Accepted solution]

hello @Diportee97 

i think the formula should be reviewed.

for example:

the first line in your screenshot

Sales Amount is $2.749,17

Unit Cost is $2.037,41

Quantity Sold is 34

if the formula is "Sales Amount - (Unit Cost * Quantity Sold)", the result will be negative.

however it will be positive if the formula is "(Sales Amount - Unit Cost) * Quantity Sold"

Hope this will help.

Thank you.