Multiple relationships with Date report filter

Hello v-yulgu-msft,

Thank you for your answer. and yes i want  my date columns in my fact table to be affected by the single Report filter.

I tried your proposition but the max (date Dimension(dates)) gives me the maximum value in the table Dimension not the maximum selected in the filter 

I even used the Function Allselected like : calculate(max( Dimension[DATE]);ALLselected(Dimension)) but it doesn't give the max selected in the filter. 

The client requires this functionality and i don't know how to do it :smileysad: