topic Re: Filtering Table with different relationships in DAX Commands and Tips

Filtering Table with different relationships

Anonymous — Wed, 18 Sep 2024 09:24:28 GMT

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!

Re: Filtering Table with different relationships

lbendlin — Wed, 18 Sep 2024 20:52:03 GMT

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?

Re: Filtering Table with different relationships

Anonymous — Mon, 23 Sep 2024 08:47:20 GMT

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.

Re: Filtering Table with different relationships

Anonymous — Mon, 23 Sep 2024 09:04:13 GMT

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.