Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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])
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |