Measure Filter not working properly in Matrix Visual

[amsrivastavaa]

Hi Folks!!

What I have done : 

Filters :

1- Project

2- Year

Measures : 

Measure2 = CALCULATE(SUM(Table1[Amount]),FILTER(ALLSELECTED('Table1'),'Table1'[Group]=MAX('Table1'[Group]) && 'Table1'[Year]=MAX('Table1'[Year] )))

Where measure2 is Sum of amount based on Group and Year

Measure3 = Divide(sum(Table1[Amount]),[Measure2])

Where Measure id division of Amount/Measure2

Selector 4 = IF([Measure3]<.25,1,0)

Where Selector 4 is the measure based on which I am filtering the tabular visual.

When, I have filtered Visual (Tabular), it gave me correct data but as soon as I try to convert it into Matrix, its not giving me correct result.

I have applied Selector 4=1 at visual level filter on both Tabular and Matrix

Can you please help me out to understand what need to be done in order to work in Matrix Visual as well.

Thanks

Amit 

PBIX is attached at below URL  

https://1drv.ms/u/s!Ahtm7otFIxr8couojYr8c06tSbM?e=DgWq9D

[Ashish_Mathur]

Hi,

I cannnot understand the question.  In the left hand side table there is no 1 in the Selector 4 column.  so when i filter the second table with selector 4=1, nothing shows up (rightfuly so).  What exactly is the question?