Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Row Total Average

Hi,   I have a matrix table as below , i am able to calculate total by using row subtotal option ,but i want average instead of total for all the feilds below .Can anyone suggest me how to do it ? ...
Show and Tell
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    We can create a measure as below to work on it.

    Measure = IF(ISINSCOPE('Table'[category]),SUM('Table'[count]),AVERAGE('Table'[count]))

     

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

Hi Anonymous ,

 

We can create a measure as below to work on it.

Measure = IF(ISINSCOPE('Table'[category]),SUM('Table'[count]),AVERAGE('Table'[count]))