I have a question. Is there a way to exclude/not use a relationshipin a measure? Something like NOTUSERELATIONSHIP? I need to keep the relationship fot other measures and analysis, but, for a specific measure I need to be able of not using this relationship.
@v-shex-msft: 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.