Forum Discussion
Multiple relationships with Date report filter
Sorry , but you cannot have more than one relationship between two tables.
So there is any other possible way to filter on the Report Date filter and my two dates be automatically included in the range chosen by the user in the filter?
Hi Hind26,
It is not possible to create multiple relationships between two tables. You want to make both two date columns to be affected by the single Report filter, right? You could use MAX(Date Dimension[Dates]) to get the selected date value, then use this expression to filter records through a measure. In that case, you don't need to create any relationship between Fact Table and Date Dimension.
Best regards,
Yuliana Gu
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:
Any proposition pleaaase :(
