Dealing with multiple references to the same table without measures

[daffodillfern]

Hi all

I'm using Salesforce data, so have a number of tables with relationships between them to link together my facts. I also already have multiple links between some of my tables and the calendar table, which means I'm using inactive relationships and measures to tell PBI which date to use. Some of my records (Accounts, Opportunities) have both a sales owner and a relationship owner which both need to link to my users table. At the moment I'm excluding relationship owners from my model, but a need has arisen to include these. I need to be able to use them in slicers, or as axis on visualisations without creating new measures, so I'm not sure how to handle there being 2 links from these tables to the User table without impacting the sales owner relationships I already use. Do I need a second user table?

Many thanks

df

[moizsherwani · Accepted solution]

@daf@daffodillfern To simply the model and create a proper star schema it would be recommended to have two user tables, one will be Sales Owner Users and the other Relationship Owner Users. There really isn't a need to create complexity in measures / visuals / report with a single user table (which usually only have a few hunderd or a few thousand records)

[daffodillfern]

Thanks Moiz

I'm fairly new to PBI so I'm pretty scared of doing something too messy or that will use too much power to process. But it seems like this will work.

Thanks

df