Cumulative Total VS Cumulative Total LY - Cleaning Visual

DAX DAX Calculations
1

I know I have seen the solution and just can’t seem to find where it was…

I have a measure for my cumulative totals:

Cumulative Total (Selected) = 
CALCULATE(
	'Total Sales',
	FILTER(
		ALLSELECTED(Dates),
		Dates[Date] <= MAX( Dates[Date])
	)
)

I create another measure for the cumulative totals last year. I have my date table set and add an area chart to my canvas. Chart has the Date as the axis and all looks good, except when I filter results by year and select 2018. Since we have data for all of 2017, the LY measure sets the axis to go to its end, as opposed to the current total end. I need to set this so when 2018 is selected, it only displays out as far as the current year MAX date for totals

image
image.png781×329 11.6 KB

2

Hi Randy, I discussed the technique to use in this video - https://www.youtube.com/watch?v=zYIxukD2KCM

Some IF logic can usually sort this.

Slight difference in the example used, but same idea.

Let me know if this works