Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Auto aggregations

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
pbi.png

Please help 😕

3 REPLIES 3
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous ,

 

You may take a look at this article.

Dealing with Measure Totals

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yulgu-msft 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.