Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to 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])
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.
@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])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |