Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Match and Count

Hello, I searched for this in the forums, but I think I'm using the wrong terms and it's not a "match and count".   I'd like to take the "Employee ID" data and count how many times it appears in the...
Need Help
  • lkalawski's avatar
    lkalawski
    5 years ago

    Hi Anonymous ,

    You can use this measure:

    CountOfEmployeeId = 
CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'), 'Table'[MGR_EMPLID] = SELECTEDVALUE('Table'[EMPLOYEE ID])))

     

    Proud to be a Super User.
    If I helped, please accept the solution and give kudos! 
    Linkedin

     

smpa01's avatar
smpa01
Community Champion
5 years ago

Anonymous  try this

Column = CALCULATE(COUNTX('Table 1','Table 1'[MGR_EMPLID]),ALLEXCEPT('Table 1','Table 1'[MGR_EMPLID]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Perfect, thank you very much!