Forum Discussion

Hind26's avatar
Hind26
Advocate 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
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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

Hind26's avatar
Hind26
Advocate 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:

  • Hind26's avatar
    Hind26
    Advocate I
    8 years ago

    Any proposition pleaaase :(

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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