Subtract Negative Values ​​From Positive Values

[samil01]

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?

[Anonymous · Accepted solution]

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.

[mlsx4]

Hi @samil01 

You will need a SUMX(Table, [calculated gross amount])

[samil01]

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?

[mlsx4]

Hi @samil01 

I will do the following:

CalculatedGrossSales= SUM('Table'[gross_amount])

And now:

Total = SUMX('Table', IF('Table'[Sales_type] = 1, -[CalculatedGrossSales], [CalculatedGrossSales]))