Forum Discussion

Still_learning's avatar
Still_learning
Frequent Visitor
5 years ago
Solved

Correctly aggregate in matrix

Hi everyone,    I have been trying this for a while now and would really appreciate your help.   I am trying to calculate the effect of price increases for individual items per sales organization...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Still_learning,

    It sounds like a common measure total level calculated issue of multiple aggregations, you can take a look at Greg's blog if it suitable for your scenario:
    Measure Totals, The Final Word 

    Regards,

    Xiaoxin Sheng

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Still_learning , try a measure like example

sumx(values(Table[sales org]), calculate(if( [Sales Price 21]> 0 && [Sales Price 19] >0,[Sales Price 21] -[Sales Price 19], blank())))

  • Still_learning's avatar
    Still_learning
    Frequent Visitor
    5 years ago

    amitchandak , thx for your help.
    Unfortunately your measure does have the same result as my previous attempt.


    P.S. I forgot to multiply the pricing difference with the quantity in my earlier screenshot so I changed that one