Filter table visual on both active and inactive relationship

Hi Nielf 

This is because when you drag columns from the Opportunity finance table into the table visual, it is still filtered by the default active relationship passed by the Account table and the Opportunity table. If you want to see results based on both relationships, you still need to create a similar measure to activate the inactive relationship to get corresponding results from the Opportunity finance table. Inactive relationships can only be used in measures. It cannot be passed in a visual invisibly. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous thanks for the swift help. That makes sense.