Can multiple slicers use multiple inactive relationships to share a role playing table?

[speedramps]

Can multiple slicers use multiple inactive relationships to share a roleplay table?

At an animal hospital there are 5 vets.

It takes any 3 vets to operate on a pet.

Vet 1 is the surgeon.

Vet2 is the anaesthetist.

Vet3 does the stitches.

 Click here to see PBIX 

There is a Dim Vet table and Fact Operations tables,

with inactive relationships and role play USERELATIONSHIP measures.

How can I change the attached PBIX to slice by vet1, vet2 and vet3?

Must I create 3 vet tables or can the 1 vet table be shared on all 3 slicers?

Thank you

[amitchandak · Accepted solution]

@speedramps , if you need three slicers to have different values, then you need three different tables and may be independent. This what I have done in the case of the date table. In my case they are joined on the same date, so no other option than an independent table. Userelationship with the single table is only useful when you choose same value

my date example: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...