Forum Discussion
Subtract Negative Values From Positive Values
Hi everyone,
Hopefully someone can help me out with my issue here, I have a condition for a measure. If sales type equal to 1 then i do want to do nothing but if its not equal to 1 i want to value minus.
Calculated Gross Amount =
VAR SelectedSalesType = SELECTEDVALUE(dwh_invoice_header[sales_type])
VAR GrossAmount = SUM(dwh_invoice_header[gross_amount])
RETURN
IF(SelectedSalesType = 1, GrossAmount, -GrossAmount)
This code works for rows but sub total is wrong.
How can i fix it?
Hi samil01
You can try the following measure
Total = IF ( [Calculated Gross Amount] > 0, SUMX ( FILTER ( dwh_invoice_header, [Calculated Gross Amount] > 0 ), [Calculated Gross Amount] ), [Calculated Gross Amount] )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Thanks for the answer,
I try to add SUMX and a write an other DAX something like this,
Total = SUMX(dwh_invoice_header,[Calculated Gross Amount])and it kind of works but the problem now is subtracts negative values twice
what i am doing wrong?
Hi samil01
You can try the following measure
Total = IF ( [Calculated Gross Amount] > 0, SUMX ( FILTER ( dwh_invoice_header, [Calculated Gross Amount] > 0 ), [Calculated Gross Amount] ), [Calculated Gross Amount] )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
