Forum Discussion
Solved
Running Total solution for slicer
Hi community I've been trying to apply solutions proposed in this forum for similar issues to mine, but have not been successful so far. I want to create either a measure or a column that can he...
Ok. I played with this some more. Please try this expression. Having account in both the table and the slicer makes this a challenge.
RunningTotal = var thisdate = CALCULATE(MAX(Total[Date]), ALLSELECTED(Total[Account]))return CALCULATE(SUM(Total[Amount]), ALLEXCEPT(Total,Total[Account]), Total[Date] <= thisdate)Regards,
Pat
Ok. I played with this some more. Please try this expression. Having account in both the table and the slicer makes this a challenge.
RunningTotal = var thisdate = CALCULATE(MAX(Total[Date]), ALLSELECTED(Total[Account]))
return CALCULATE(SUM(Total[Amount]), ALLEXCEPT(Total,Total[Account]), Total[Date] <= thisdate)
Regards,
Pat
Oh! This works!!
I just took out the account column from the table, just kept it in the slider and now all numbers show as expected.
Thank you so much Pat!