Grouping and counting a secondary related table

[MattGo]

I'm using a dataset from Dynamics365 which has 3 entities: service, attendance and contact. The attendance entity acts as a link between the Service and the Contact.

I want to display a breakdown, filtered by service, of the counts of specific fields in contact. For example, for Service A I want to see a count of how many contacts of each age are related. I'm trying to wrap my head around a query to do this and I'm just getting myself confused.

My understanding is I need to:

Get attendances from the desired service (slicer?)

Get contacts from those attendances

Group and count the age field on those contacts

Is there a way to do this in PowerBI? Thanks

[v-deddai1-msft]

Hi @MattGo ,

Roughly looking at your description, this can be achieved in power bi, but without your sample data and the desired output, it is difficult for us to help you.

Would you please inform us more detailed information( your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.

Please don't contain any Confidential Information or Real data in your reply or files.

Best Regards,

Dedmon Dai

[parry2k]

@MattGo can you share the sample data or pbix file and expected result.