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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.