Count of Activities (Owner and Optional)

[juanso14]

Hello, I would like to know how many activities do a user in Dynamics 365 CRM. But I want to know the own he creates, but also the users that attend like an optional. CRM has a view that is My activities, that include those ones. 

I know that the column is ActivityParty.ParticipationTypeMask and the options 6 and 9.  But I don't know how to link and show the count of activities.
  Best Regards,  Juan

[v-lid-msft]

Hi @juanso14 ,

Sorry for that, We cannot understand your data model clearly, Could you please provide a sample mockup table based on fake data or describle the fields of each tables and the relations between tables simply? Please don't have any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[juanso14]

 The idea is to see the same view than my activities, in power bi. 

Thank you 

[juanso14]

I want to know if some user participate under the column participationtypemask as 5 or 8 in one activitie and to count how many activities participate. Is that possible?