Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello,
I want to reproduce this table in power bi, i have four calculated measures ( the ones in white ) and i want to have this matrix in power bi in wich i can add rows of sum and average that will be automatically calculated, ( sum and average of these measures )
I also want to write manuall the names of the columns, wich i can't figure how to do it in PBI..
Just like in excel where i can put formulas in the cells that will auto calculate
Please help 😕
Hi @Anonymous ,
You may take a look at this article.
Best regards,
Yuliana Gu
it does not really answer my question,
"moyenne" means average and "somme" means sum, i don't have a field with sum and average for that reason i can't add rows that will auto aggregate my measures
Hi @Anonymous ,
Please illustrate with dummy data and show us desired output.
How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 44 | |
| 42 | |
| 40 | |
| 40 |