Forum Discussion
Adding an average column to a matrix
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/
Super UserAnonymous , 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/
What would the measure and av measure be?
- amitchandak
Anonymous ,
measure = sum(Table[Value])
Avg Measure = Average(Table[Value])
or
Avg Measure = Divide(sum(Table[Value]), distinctcount(Table[Company]))
Hi Amit. this is working now however the sub-total is s
howing the sum and not the average