Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have year qtr and running count for years based head count . I just want to filter using the slicer and get the running total value for a specific qtr for a year
I have created the running total count based on
Running Total Count =
CALCULATE(
[TOTAL COUNT],
FILTER(
ALLSELECTED(‘All’[Year QTR]),
ISONORAFTER(‘All’[Year QTR], MAX(‘All’[Year QTR]), DESC)
)
)
I have year qtr and total in the table when I tried to filter say 2021 Q1 i would like to see the running total all the way to 2021 Q1 instead of just the count for the specific quarter
if anyone has better solution to achieve this please share
Solved! Go to Solution.
@rajaurora
Try this please:
Running Total Count =
CALCULATE(
[TOTAL COUNT],
FILTER(
ALL(‘All’[Year QTR]),
ISONORAFTER(‘All’[Year QTR], MAX(‘All’[Year QTR]), DESC)
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you so much it worked great ..Awesome
@rajaurora
Try this please:
Running Total Count =
CALCULATE(
[TOTAL COUNT],
FILTER(
ALL(‘All’[Year QTR]),
ISONORAFTER(‘All’[Year QTR], MAX(‘All’[Year QTR]), DESC)
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |