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

[niculeica]

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.

Any idea what could possibly cause it?

[niculeica]

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 · Accepted solution]

@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])