Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate Appointment participants

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...
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Write this measure

     

    Number of Organisers = DISTINCTCOUNT(Data[Organizer])

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Write this measure

 

Number of Organisers = DISTINCTCOUNT(Data[Organizer])

 

Hope this helps.