Forum Discussion
Average the averages within a Matrix?
Is there a way to have the Matrix visualization average all the rows, but have the grand total average the averages? Please see screenshot below. I have "elements" which you see all begin w...
amitchandak
Super User
Super UserbwanRPD , Using the columns in the matrix
Averagex(Addcolumns(Summarize(Table, Table[Buliding], Table[Element]), "_1", [Avg]), [_1])
Sorry, one more question, if your DAX, what is [Avg]? is that a different table that you are referencing?