Use USERELATIONSHIP more than twice in a single measure

[michael_knight]

Hi,

I'm trying to create a measure that will use the slicers that I have. The three slicers are Date, Company and Owner

I am able to use the USERELATIONSHIP function twice and it works fine with the slicers etc but I have problems when I try to add the third

This is what I get when I add the third USERELATIONSHIP 

This is what the relationships looks like

Here's the PBIX file

https://www.dropbox.com/s/ftn5q3g388azvn5/Completions%20-%20Copy.pbix?dl=0

Cheers,

Mike

[michael_knight]

Cheers guys @amitchandak  @parry2k 

I created another table with the Company name in and stuck with the orginal Owner relationships. The reason being is that we use live data and the owners change quite frequently, and the USERELATIONSHIP function works with twices so I'm happy with that

I am still learning about Power BI and I think relationships is somewhere I can improve. I've heard a lot about Star Schemas so maybe I need to learn how to do that 

Cheers,

Mike

[amitchandak]

@michael_knight , Thanks for sharing how exactly it worked for you. All of us are learning. Power BI is an Ocean. 😀

[amitchandak]

Reposting - last one did not get saved

@michael_knight , YOu nee check why you have many to many between forecast and comp. Can this be made 1-M. Need of composite key?

Try to have a bridge table

https://www.seerinteractive.com/blog/join-many-many-power-bi/

But you need to avoid the loops in join

[parry2k · Accepted solution]

@michael_knight your model design is poor, you should create seperate table for owner and company and create relationship of these new tables with forecast and comp, and make all relationship active

don't have relationship between comp and forecasr tables, 

when above all done, use column from respective dimension table and measure from forecast and comp table and everything will work as expected.

@Anonymous check if this sensitivity labels get what you are looking for, I cannot think of anything else.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡