Forum Discussion

Hind26's avatar
Hind26
Icon for Advocate I rankAdvocate I
8 years ago

Multiple relationships with Date report filter

Hi, I have a Fact Table that contain two different Date (exple : Creation and Update) and i have Date Dimension, beside all this i have a Date Report filter that i did from my Date dimension and i w...
Need Help
Hind26's avatar
Hind26
Icon for Advocate I rankAdvocate I
8 years ago

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:

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Hind26,

 

Did you add the dimension[dates] into report level filters? Did you remove the the relationship between fact table and dimension table? In my test, I could get the selected date using max (date Dimension(dates)). Please try whether select date = SELECTEDVALUE(Dim[Date]) works.

 

Regards,

Yuliana Gu