Exclude relationship

Hi Anonymous and Zubair_Muhammad. Thanks both for your replies.

Anonymous: I've already tried that without success. It does not work in this scenario like we wish.

Zubair_Muhammad: The problem is, that in the visual I need the interaction ACTIVE because I need to use measures that work with this relationships.

The report that I need to make, has a Matrix visual with several measures. In the report, I also have 2 date slicers, each slicer working with a different date table. Both tables, related to the same fact table. So, here is the problem. I need to use some kind of NOTUSERELATIONSHIP in the measure that has to work with Date2 table and not with Date1 table.

The changes that I made so far to make this work, was to create a reference of the Fact table. So, my final model has Date1 table related to Fact1 table, ande Date2 table related to Fact2 table. I whas hopping that I can avoid this so I don't need to have a duplicate of the Fact table.

The other solution would be to leave 1 Fact table realted to both Date tables but with the relationships disable, and in each measure select the desire relationship using USERELATIONSHIP. The problem is that I have so many measures already created, that I would take to long to perform this. So, I choose the first solution mentioned above.

If anyone has any other options, be welcome to share it.

Thanks for your help!