Cumulative Total to only show certain dates without the running total being impacted

[Anonymous]

Hi All, 

Im a bit stuck on one thing. I have a cumulative total graph with dates on the x-axis that span from 2018 onwards. I only want to show dates from 2020 onwards but i want to cumulative total to calculate from the first date point rather than calculating from 2020 onwards.

I just want my graph to not show dates from 2018 but i want the running total to account for the values from 2018 (if that makes sense).

When i use ALL measure, while i can conntrol what dates are shown, the issue becomes that the graph doesn't slice correctly. 

Is there a way i can still use ALLSELECTED (so that the grpah can be sliced properly) to show cumulative total but have it that my x-axis shows dates from jan2020 onwards. Value for Jan2020 should be an accumulation of active/cancelled row count from the min date up to jan 2020 and then cumulation should continue to max date. 

Please find PBIX and data for more info.

THank you so much in advance.

[amitchandak · Accepted solution]

@Anonymous , Try , a measure like 

new measure =
var _1 = Cumm Sales = CALCULATE(SUM(Table[value]),filter(allselected(Table),Table[Date] <=max(Table[Date])))
return
if(max(Table[Date]) <= date(2018,1,1) , blank(),_1)

[Icey · Accepted solution]

Hi @Anonymous ,

You can also try this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Try , a measure like 

new measure =
var _1 = Cumm Sales = CALCULATE(SUM(Table[value]),filter(allselected(Table),Table[Date] <=max(Table[Date])))
return
if(max(Table[Date]) <= date(2018,1,1) , blank(),_1)