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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
niculeica
Helper I
Helper I

Totals on Quarter do no reflect SUM(Totals of Months)

Hi, PBI community,

 

I'm experiencing some troubles with displaying Quarter Totals, namely they do not reflect the SUM of Month's Totals, but the total of the last month of the quarter.

 

I'm working in a matrix, and everything seems fine in terms of calculations, however the totals do not cummulate accordingly.

 

niculeica_0-1698797387912.png

 

Any idea what could possibly cause it?

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@niculeica , This can happen when you use row context in meausre

Assume your measure is M1

Create a new measure 

 

M2= Sumx(Summarize(Fact, Date[Month], Fact[Type], "_1", [M1]) , [_1])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
niculeica
Helper I
Helper I

Thank you, @amitchandak, the solution turned out to be the one needed.

 

With this settled, is it possible to calculate M2 as a running total, M3 let's call it? I've tried even the quick measure's Running total, and won't return the expected. It actually returns the same as M2.

amitchandak
Super User
Super User

@niculeica , This can happen when you use row context in meausre

Assume your measure is M1

Create a new measure 

 

M2= Sumx(Summarize(Fact, Date[Month], Fact[Type], "_1", [M1]) , [_1])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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