Forum Discussion
negative values is not adding up
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.
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])
6 Replies
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
No i need in same column i tried your solution answer is wrong.
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.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
Hi, alamhaz ；
If you can share simple files, it will be better to remove sensitive information.
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])
