Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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