How do you change the tables in chart filters

Question

I am working on a report that shows 3 different figures and a bar chart with some slicers 

The Table is shown below

A	B	C	D
A1	1	9	20
A2	2	8	20
A3	3	7	20

Measure 1 - C/D 

Measure 2 - Calculate( Measure 1, AllExcept('Year'))

Measure 3 - Calculate( Measure 1, AllExcept('B'))

And the Bar Chart has  X Axis - B , (Drilldown A) 

Y Axis - Measure 1

If I use slicers the figures are changed correctly but if I select the bar chart, Measure 2 does not show the correct number 

How do you make Measure 2 to be able to change based on the chart 

Answer 1

Hi,

You can use the following measure.

Measure 2 = CALCULATE ( [Measure 1], FILTER ( Table, Table[Year] = MAX ( Table[Year] ) ) )

This can be done with the help of DAX in power BI