Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Sum (%) column in MATRIX PREVIEW

I want to calculate profitability
A. Sale
B. Cost
C. Profit = (A-B)
S.% Profit  = ( A-B ) / A 

 

I would have expected the summary to be the same,
but rather that it sums up instead of calculating a percentage.

Especially in collaps up situation 

I have tried also this  Show Values As => Percent of Row Total  and all others 

 

Thanks

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hello cs_skit

     

    This is did not help (?) 

     

    But it did solve the problem

     

    Average CUSTNAME = AVERAGEX(KEEPFILTERS(VALUES('INV-AMI'[CUSTNAME])),CALCULATE(AVERAGE('INV-AMI'[profit%]))

     

    I donwt know why...

    Still, I learned a lot

    Thanks 

2 Replies

  • cs_skit's avatar
    cs_skit
    Resolver IV
    9 years ago

    for profit and percentage do measures instead of calculated columns then it works:

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hello cs_skit

       

      This is did not help (?) 

       

      But it did solve the problem

       

      Average CUSTNAME = AVERAGEX(KEEPFILTERS(VALUES('INV-AMI'[CUSTNAME])),CALCULATE(AVERAGE('INV-AMI'[profit%]))

       

      I donwt know why...

      Still, I learned a lot

      Thanks