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, 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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |