Forum Discussion
How do I stop Running Total Quick Measure from continuing to display beyond values entered
I was able to create a quick measure for running total (great new feature!), but my line chart for this running total measure continues beyond the values entered. Quck Measure is a running total...
Hi Anonymous,
As MattAllington said, you can add a condition to check if the week number is less than current week number.
Sample:
2017 Pre-Con Total (by Weeks Out) = CALCULATE( [Pre-Con Active Total], FILTER( ALLSELECTED('Reference'[Weeks Out]), ISONORAFTER('Reference'[Weeks Out], MAX('Reference'[Weeks Out]), DESC)&&'Reference'[Weeks Out]<= MAX('Reference'[Weeks Out]) ) )Regards,
Xiaoxin Sheng
Hi Anonymous,
As MattAllington said, you can add a condition to check if the week number is less than current week number.
Sample:
2017 Pre-Con Total (by Weeks Out) =
CALCULATE(
[Pre-Con Active Total],
FILTER(
ALLSELECTED('Reference'[Weeks Out]),
ISONORAFTER('Reference'[Weeks Out], MAX('Reference'[Weeks Out]), DESC)&&'Reference'[Weeks Out]<= MAX('Reference'[Weeks Out])
)
)
Regards,
Xiaoxin Sheng