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/
