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
| User | Count |
|---|---|
| 23 | |
| 19 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 60 | |
| 52 | |
| 47 | |
| 40 | |
| 38 |