cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hfoth Member
Member

Exclude relationship

Hi community!

 

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.

 

Thanks in advance.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Exclude relationship

HI @hfoth,

 

Current it seems not contains functions who can break specific relationship, maybe you can try to add all function on source table of specific measure to breaks its filter effect.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Super User
Super User

Re: Exclude relationship

@hfoth

 

Another option could be to use EDIT INTERACTIONS from the FORMAT tab and DISABLE the interactions between the desired VISUALS

hfoth Member
Member

Re: Exclude relationship

Hi @v-shex-msft and @Zubair_Muhammad. Thanks both for your replies.

 

@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.

 

Thanks for your help!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 154 members 1,932 guests
Please welcome our newest community members: