Filter Chart based on MAX of date slicer

[AFinster]

Hi all,

I need additional help based on a previous solution: Filter Table based on MAX of date slicer 

What I need is to not only filter a table based on a "Before"-based date slicer (already solved above), but to also show the same results in a chart filtered using the same date metric / slicer interface.

Link to pbix 

Link to Excel data 

Any thoughts?

Thanks in advance,

Adam

[amitchandak · Accepted solution]

@AFinster , you can not put a visual level filter for that, you need to have measure like this

measure=

var _min =MAxX('Date','Date'[Date])
return
CALCULATE('Table'[Sales], Filter(Date,'Date'[Date] =_min ))

[AFinster]

Thanks @amitchandak ,

I modified the measure to suit my examples:

Sales by Company =

VAR _max = MAXX(WeekData, WeekData[ToDate])

RETURN

CALCULATE(SUM(Sales[Sales]), FILTER(sales, Sales[Week Ending] = _max))

as the CALCULATE() function needed the SUM() function in the 1st parameter for it to work. This worked exactly as I needed!