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 calcula...
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 

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