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.
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
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
