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 Appl...
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/
What would the measure and av measure be?
amitchandak
Super User
Super UserAnonymous ,
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