Forum Discussion
Running total: Column vs Measure
Hello, all I have the following problem: from a database that contains a date column; country column; city column and an event name column, I want to display a line chart that accounts for the ac...
Hi mrs13
Definitely stick with the calculated measure approach, so you can keep it dynamic.
Can you please share the code you are using for your calculated measure?
Hello, Phil
Thanks for your answer. I am using the following code:
Running Total =
CALCULATE(
COUNTA('Database'[Events]);
FILTER(
ALL('Database'[Date]);
ISONORAFTER('Database'[Date]; MIN('Database'[Date]); DESC)
)
)