Forum Discussion

alamhaz's avatar
alamhaz
Helper I
5 years ago
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...
Need Help
Tips and Tricks
  • alamhaz's avatar
    alamhaz
    4 years ago

    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])
alamhaz's avatar
alamhaz
Helper I
4 years ago

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