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, community,
Having some troubles making Running Total ignore Year slicer. I've read a couple of similar threads, however, I'm still missing something 😞
So I have a Transactions table and a Period table based on it [Calendar(Min,Max)]. I've used the below formula to display Running totals per each period, but if I select a specific year in Year filter, the Running total starts with the first period of that year (it's cutting out anything before, not summing it up). I've tried with ALLEXCEPT('_Period'[_Year]) or even with ALL('_Period') and same result (Year field belongs to Period table as well).
Any idea what I could go for here?
Solved! Go to Solution.
_Revenue running total in Period = //Try this one
CALCULATE(
SUM('TransactionsbySegment'[_Revenue]),
FILTER(
ALL('_Period'),
'_Period'[_Period Sort] <= MAX('_Period'[_Period Sort])
)
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
_Revenue running total in Period = //Try this one
CALCULATE(
SUM('TransactionsbySegment'[_Revenue]),
FILTER(
ALL('_Period'),
'_Period'[_Period Sort] <= MAX('_Period'[_Period Sort])
)
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |