Forum Discussion
Solved
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 g...
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])
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.