Forum Discussion
Solved
Running Total Breaks when Adding Top N
Hello! I'm trying to obtain obtain a running total. I have the DAX working: Running Total =
VAR thisCategory = [sum Total Monthly Cost]
VAR RunningTotal_ThisCategory =
CALCULATE(
...
Indeed, thanks! Just wish I knew what was wrong!
- Fowmy
Super User
Sburi2
When you posted the question initially, I noticed that you had used ALL instead of ALLSELECTED. It was one reason for the incorrect results when you applied TOPn filter. Apart from that you also had applied some other filters.ar __all = CALCULATE( [Total Sales] , ALLSELECTED(financials[Product]))