Calculate Appointment participants

[Anonymous]

Hi,
I'm totally new to everything PowerBI and have previously worked mostly in development, as such im not to experienced with Excel either, so bare with me 🙂

I got a problem that that making me bald, it's quite complex (I think). Basicly I have a Dataset of Appointments from Dynamics that contains:

• Date 
• Organizer (1 name)
• Participants (0-N names delimited by ";")
• Subject (Meeting Subject)
• Regarding (Name of the regarding case)

So i want to make a graph that shows the attendence count of each organizer and participant in a given timeframe.

Count on the Y and Name of Person on X.
I have tried to split the participants column into multiple rows, but then i get lost with the counting since organizer the appears over multiple rows on the same Appointment. So i need to count the individual participants and organizer on each appintment but make sure that the organizer just being counted once for each exact date.

I feel that im just running in circles, anyone here have some good ideas on this issue?

Thanks a bunch

[Greg_Deckler · Accepted solution]

I would split that column out and then unpivot the column so that you end up with one row per participant for each appointment. Then the counting should be trivial.

[v-chuncz-msft]

@Anonymous,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Summarising-Actual-and-Target-Hours/m-p/405633#M185682

[Ashish_Mathur · Accepted solution]

Hi,

Write this measure

Number of Organisers = DISTINCTCOUNT(Data[Organizer])

Hope this helps.

[Greg_Deckler · Accepted solution]

I would split that column out and then unpivot the column so that you end up with one row per participant for each appointment. Then the counting should be trivial.