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.
Hi guys,
Im hoping somone can help me.
I currently have the following measure :
CM 2022-23 (Ton) =
CALCULATE(
SUM('Table_ALL'[Tonnage]),
'Table_ALL'[FY] IN { "2022 23" } &&
'Table_ALL'[Type] IN {"Co-mingled"}
)
I need to amend this to a running total. I am unsure how to do this since I have multiple criteria.
For example I am currently bringing back the Tonnage of co-mingled waste from the FY 2022-23, The client wants a line per waste type to be plotted per year, however the ask is thats its plotted on one axis so lines appear above and below it I have done this by putting month on x-axis as a text so can see trends for same months in previous years.
Can someone please assist?
Solved! Go to Solution.
HI guys,
Managed to find a solution for this where I duplictated the original table, created groups per category and calculated running total as a function.
following this I amended my orginal Dax measure to reference newly created table and now have running totals per group and FY as per clients request.
HI guys,
Managed to find a solution for this where I duplictated the original table, created groups per category and calculated running total as a function.
following this I amended my orginal Dax measure to reference newly created table and now have running totals per group and FY as per clients request.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |