topic Need help adding a second layer of matrix header to group my measure calculations in DAX Commands and Tips

Need help adding a second layer of matrix header to group my measure calculations

Anonymous — Wed, 21 Apr 2021 01:40:58 GMT

Please I will need help adding a second layer of matrix header to group my measure calculations.

Origna Matrix table:

Desired Result:

Category is a colum from the table place in the Matrix Rows

Total 1, Total 2, Average 1 Average 2 are all explicit measure placed on Matrix Values

Sum Calculations and Average Calculationsare are not columns in the table, but just abstract words I will like to use for grouping..

amitchandak — Wed, 21 Apr 2021 04:12:20 GMT

Anonymous , Refer if these old solutions can help

Anonymous — Wed, 21 Apr 2021 04:22:07 GMT

amitchandak Thanks for your response, unfortunately I had seen some of them, the problems are different, so they did not help.