Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |