How do I stop Running Total Quick Measure from continuing to display beyond values entered

[Anonymous]

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 of Pre-Confernece registration by weeks out from our conference. 

DAX:

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)
)
)

[Pre-Con Active Total] = Count of Pre-Con registrations with blanks filtered out

'Reference'[Weeks Out] = Reference column to use as X-Axis in charts. Relationship between registration date and this column allows me to compare YoY numbers by Weeks out from the conference. 

My problem is that my line chart continues beyond our current weeks out (12) to 0 weeks out with a continuous line. Is there any way to edit my running total so that only values on or before today are shown in the line chart? 

[Anonymous · Accepted solution]

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

[MattAllington]

Einer load your calendar table up to he current week, or use an if statement to check if the current week has a value, and return blank if it doesn't.