Forum Discussion

bwanRPD's avatar
bwanRPD
Frequent Visitor
4 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

bwanRPD , Using the columns in the matrix

 

Averagex(Addcolumns(Summarize(Table, Table[Buliding], Table[Element]), "_1", [Avg]), [_1])

bwanRPD's avatar
bwanRPD
Frequent Visitor
4 years ago

Hi, sorry I am not as familiar with writing DAX in PBI. Am I adding this in as a measure within the Matrix, or a separate column in the data table?

The DAX you provided gives a couple tables in the parameter, but the "Building" and "Element" is all part of the same 1 table.