multiple cross filters between two tables

[Anonymous]

I have two tables between which I have created three cross filters. Date, place and department.
Unfortunately, I can only activate one cross filter.
Is there a way to activate all cross filters?
Thanks

Volker

[Anand24 · Accepted solution]

Hi @Anonymous ,

You can have only 1 active relationship between any 2 tables in the model.

You can use below 2 methods to achieve ,multiple mappings:
1. Create inactive relationships and then use USERELATIONSHIP dax function to activate them in your calculations.

2. Create copy of 1 of your tables and have active relationship. Take slicer fields from these copied tables.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!