Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Filtering Table with different relationships

Hi, I am using 2 different date columns for each bar visual (Forecast e6 date, e6 achieved date). I connect both of the date columns to a Dimcalendar table, and use CALCULATE...USERELATIONSHIP ...
DAX
powerbi
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from lbendlin.

     

    Hi Anonymous ,

     

    According to your description, the two bar charts cannot interact with the table. I tried to reproduce your problem.

     

    The model is as follows:

     

    This is due to the fact that the current relationship is inactive. Even when using the USERELATIONSHIP function, the function only activates the relationship when performing a summation calculation. It is recommended that both relationships be set as active to ensure that the bar chart and table can interact properly.

     

    The new model is as follows:

     

    Result:

     

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

for better or for worse Power BI does support bidirectional search between tables (most often in a *:* relationship)

 

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?