Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
daffodillfern
Frequent Visitor

Dealing with multiple references to the same table without measures

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

1 ACCEPTED SOLUTION
moizsherwani
Continued Contributor
Continued Contributor

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

Thanks,

Moiz
Was I able to answer your question? Mark my post as a solution to help others. Kudos if you liked the solution.

View solution in original post

2 REPLIES 2
moizsherwani
Continued Contributor
Continued Contributor

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

Thanks,

Moiz
Was I able to answer your question? Mark my post as a solution to help others. Kudos if you liked the solution.

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.