AnonymousNot applicable5 years agoSolvedMatch 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...Show Morelkalawski5 years agoHi 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
lkalawski5 years agoHi 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
lkalawski5 years agoHi 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
lkalawskiResident Rockstar5 years agoHi 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
Related contentCounting nullsissue count number of matching values.Count Non Matching RowsHow to get Count from two different table- Un-match Count Table Record with New TableCount Of Drivers
