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]))

     

gpoggi's avatar
gpoggi
Responsive Resident
6 years ago

Hi there, it would help if you can share your current SUM measuare but you can try something like this:


YourMeasure1 = SUM(Table1[Column1]) or CALCULATE(SUM(Table1[Column1]),FILTER1)
YourMeasure2 = AVG(Table1[Column1]) or CALCULATE(AVG(Table1[Column1]),FILTER1)

YourMeasure3 = IF(ISBLANK(SELECTEDVALUE(Table1[User_Display_Name])),YourMeasure1,YourMeasure2)

Hope this helps, If not, feel free to share your more details like your current calculations so we could try to help you in a better way. 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Regards,

 

Gian Carlo Poggi