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])
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

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

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's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, alamhaz ；

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