Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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])
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |