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.

Anonymous's avatar
Anonymous
Not applicable
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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.