Forum Discussion

Noredlac86's avatar
Noredlac86
Helper I
4 years ago
Solved

Count repeated values with a condition

Hi Everyone. I waswondering if someone one can help me with this doubt.   I have a table with the name of the employees, and the column, Employe of the month = Yes/No.   I need to count, how man...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Noredlac86 Maybe:

    How many times column =
  VAR __id = [ID]
  VAR __table = FILTER(ALL('Table'), [ID] = __id && [EMPLOYEEOFMONTH?] = "Yes")
RETURN
  COUNTROWS(__table)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Noredlac86 Maybe:

How many times column =
  VAR __id = [ID]
  VAR __table = FILTER(ALL('Table'), [ID] = __id && [EMPLOYEEOFMONTH?] = "Yes")
RETURN
  COUNTROWS(__table)
Noredlac86's avatar
Noredlac86
Helper I
4 years ago

Greg_Deckler i have tested and i just wanna say THANKS!!!!!
Thanks for take your time to reply my message is working fine, u rock!