Forum Discussion

samil01's avatar
samil01
Frequent Visitor
3 years ago
Solved

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 valu...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

samil01's avatar
samil01
Frequent Visitor
3 years ago

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's avatar
mlsx4
Memorable Member
3 years ago

Hi samil01 

 

I will do the following:

CalculatedGrossSales= SUM('Table'[gross_amount])


And now:

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