Forum Discussion

PaulCo's avatar
PaulCo
Helper II
8 years ago
Solved

Calculation based on Column Average

I am pulling data from SFDC which contains the Value of each deal booked and also the discount used for the deal. I want to summarise the data by month to show the Total Value, Average Value and then...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi PaulCo,

     

    To achieve your requirement, create a measure using measure like below:

    Measure = CALCULATE(SUM(Table1[Weighted Average Discount]), ALLEXCEPT(Table1, Table1[Month]))

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi PaulCo,

 

To achieve your requirement, create a measure using measure like below:

Measure = CALCULATE(SUM(Table1[Weighted Average Discount]), ALLEXCEPT(Table1, Table1[Month]))

 

 

Regards,

Jimmy Tao

PaulCo's avatar
PaulCo
Helper II
8 years ago

Perfect, thanks.

 

I had to do a couple of intermediateary steps but I got there with the help of your example.