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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
marina_oliveira
Frequent Visitor

Calculated column sum grouped

Hello everyone!

So, I have this table (fVolume) with information separated by Month_Year and Center (Unidade). A Center belogs to a Region, and a Region can have multiple Centers. I want to calculate the sum of the volume per Month_Year per Region. I was thinking of a calculated column, but it can be a measure too, I don't know... Can you guys help me?

 

marina_oliveira_0-1679422826479.png

marina_oliveira_1-1679422861776.pngmarina_oliveira_2-1679422901695.png

 

 

1 REPLY 1
tamerj1
Super User
Super User

Hi @marina_oliveira 

please try

Coluna =
CALCULATE (
SUM ( 'Table'[Volume Mes Corrigido] ),
ALLEXCEPT ( 'Table', 'Table'[Mes_Ano] )
)

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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