negative values is not adding up

[alamhaz]

Hi there 

I need solution for this , my senario is that i am using one if condition on one measure that is

( if measure <0, measure1 * measure 2, 0) but when i put in table its not adding up only giving me 0 , if instead of 0 i give 1 in sum its giving me instead of suming up negative values. check the attached screen shot. 

[alamhaz · Accepted solution]

Thanks for reply i solved the issue just use value function as below 

Avg Sale lost (Sum) = SUMX(VALUES('Product Movement'[Date]), [Avg Sale Lost])

[v-yalanwu-msft]

Hi, @alamhaz ;

You could create a measure as folllow:

Avg Sale Lost =
VAR _tab =SUMMARIZE ('Table',
        [Index],
        "1",IF ( [Total Qty Diff Avg] < 0, [Avg Selling Price] * [Total Qty Diff Avg], 0 ))
RETURN
    SUMX ( _tab, [1] )

 The final output is shown below:

If it not right ,can you share me simple file without sensitive information?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alamhaz]

Hi thanks for answer but its is suming up but not multiplying as desired see the screen shot its supposed to multily because total Qty diff is less then 0 but its not and when i put this meaure in card its showing 0 , not negtive or postive values 

[v-yalanwu-msft]

Hi, @alamhaz ；

If you can share simple files, it will be better to remove sensitive information.

[PaulDBrown]

Try:

Avg Sale lost (Sum) = SUMX(Table, [Avg Sale Lost])

Where " Table" refers to the table you are using for the row context in the visual

[alamhaz]

No i need in same column i tried your solution answer is wrong.