Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
naninamu
Helper IV
Helper IV

Data modelling with multiple tables

‎02-23-2023 02:56 AM

Hi forum,

 

I'm trying to understand if I can achieve what I want given the data model I have.

 

My model is made up of multiple tables - I know it's not very "Star", but I don't think it lends itself to that as all the tables literally link to each other via the ID field.

 

naninamu_0-1677149597090.png

 

What I'm trying to do is work out how many people from each Cluster (top table on the right - using the Name field) are of Aboriginal Descent (defined in the Applicant table bottom right). Although all the tables are linked via various ID fields, it is a mix of 1 to many and many to 1 relationships and the 2 tables are quite far apart.

 

Is it going to be possible for me to calculate what I'm after, I'm a bit confused!

 

Thanks, Andrew

Labels:
Message 1 of 1
939 Views
0
0 REPLIES 0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All