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])
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.