Filtering Table with different relationships

[Michie_24]

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 in the measures to calculate the count of each bars in both charts shown. I am struggling to get the bottom table to filter accordingly.

Example: I would like it to show the relevant job when I click on one of the weeks on the top barchart, and vice versa that it shows the relevant job when I click on the bottom bar chart. 

Thank you!

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin.

Hi @Michie_24 ,

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.

[Michie_24]

Hi Zhu, 

Thanks for your confirmation that the two bar charts cannot interact with the table by using USERELATIONSHIP. The reason that I am using inactive relationships is because the dates are from the same table. So, at least now i know that in order for me to get the right filters on the table, I need to split the dates to different tables and have active relationships for both. 

Thanks again. 

[lbendlin]

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?