Count repeated values with a condition

[Noredlac86]

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 many times of the year, the user was employee of the month.

For example:

ID    NAME     EMPLOYEEOFMONTH?     HOW MANY TIMES?

5    Jhon                  Yes                                        2

5     jhon                  No                                        2
6    Ana                    No                                       0
7    Marc                  Yes                                       3
5   Jhon                    Yes                                      2
7  Marc                     Yes                                      3
7 Marc                     Yes                                      3

The idea is to create the column "How many times?

iwas wondering if someone can help me

[Noredlac86]

@Greg_Deckler  i have a hard question for you. This is so dificult, but not sure if you have time to check:

https://community.powerbi.com/t5/Desktop/Power-BI-DAX-count-using-multiple-and-hard-conditions/m-p/2...

Really appreciate your feedback

[Greg_Deckler · Accepted solution]

@Noredlac86 Maybe:

How many times column =
  VAR __id = [ID]
  VAR __table = FILTER(ALL('Table'), [ID] = __id && [EMPLOYEEOFMONTH?] = "Yes")
RETURN
  COUNTROWS(__table)

[Noredlac86]

@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!