Forum Discussion
Adding an average column to a matrix
Hi All, I have the following matrix
Row: Group name (A, B, C, D)
Columns: Company Name ( Apple, Google, Tesla). HERE I want to add an average column.
Values: Any numbers
| Group | Apple | Tesla | AVERAGE | |
| A | 1 | 2 | 3 | |
| B | 2 | 3 | 2 | |
| C | 3 | 4 | 3 | |
| D | 4 | 5 | 1 |
I want to add an average column that looks at te average for the companies selected. How can I do this?
Anonymous , isinscope can help, Make sure you have measure and Avg Measure then
a measure like
if(isinscope(Table[group]) && not(isinscope(Table[Company])), [Avg Measure], [measure])
Add column subtotal in matrix, this should give avg in column sub total
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
4 Replies
Anonymous , isinscope can help, Make sure you have measure and Avg Measure then
a measure like
if(isinscope(Table[group]) && not(isinscope(Table[Company])), [Avg Measure], [measure])
Add column subtotal in matrix, this should give avg in column sub total
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/Anonymous ,
measure = sum(Table[Value])
Avg Measure = Average(Table[Value])
or
Avg Measure = Divide(sum(Table[Value]), distinctcount(Table[Company]))