The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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..
@Anonymous , Refer if these old solutions can help
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
@amitchandak Thanks for your response, unfortunately I had seen some of them, the problems are different, so they did not help.
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |