Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average of table

i have a matrix table as per screenshot with setup   what i would like to achieve is create a column on the right with the average of the 5 columns totals  Stuck on how to achieve th...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Is this data in your screenshot the sum value for each product?(Simplely means one product has more than one value for each Year/Q)

    If so, i create two new tables to test:

       

    Create a sum measure for each product of each Year/Q:

    Measure = SUM('Product'[Values])

    Then create an average measure for each Year/Q:

    Average = CALCULATE(SUM('Product'[Values]),ALLEXCEPT('Date','Date'[Q],'Date'[Financial Year]),ALLSELECTED('Product'[Product]))/3

    Choose these two measures and follow my previous reply's steps, it shows:

    Here is my test pbix file:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Is this data in your screenshot the sum value for each product?(Simplely means one product has more than one value for each Year/Q)

If so, i create two new tables to test:

   

Create a sum measure for each product of each Year/Q:

Measure = SUM('Product'[Values])

Then create an average measure for each Year/Q:

Average = CALCULATE(SUM('Product'[Values]),ALLEXCEPT('Date','Date'[Q],'Date'[Financial Year]),ALLSELECTED('Product'[Product]))/3

Choose these two measures and follow my previous reply's steps, it shows:

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-gizhi-msft 

thats it

 

fantastic

thankyou so much