Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure with user attendance

Hello,   I would like to calculate staff attendance to training sessions.   See the sample table below. I guess I am getting all to show 100% because the DISTINCTCOUNT is being filtered by user ...
Need Help
  • tex628's avatar
    tex628
    7 years ago

    I think this should work: 

    Measure = 
DIVIDE(DISTINCTCOUNT('Sample'[Session]) , CALCULATE(DISTINCTCOUNT('Sample'[Session]) , ALL('Sample')) , BLANK())
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

Just have to check, you wrote 33 sessions previously but i can only find 19 unique session. Did i miss something? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Not sure what to answer. Measure 1 is counting the number of sessions. It reads 16.

Why would Measure 2 count 19...? :-s

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Lets take the logic step by step!  


    Each unique date in the sample data represents a unique session. In the dataset there are a total of 19 different dates. This must mean that there are a total of 19 potential sessions that each user can go to, right? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Yes! 19 different sessions. That is correct.

    I was counting 16 because I had another slicer applied. My mistake.