Identifying repeating users who also meet a condition

[user900]

Looking for some help. I have a table with user name, month, and status. I need to identify which users have a status of "Fail" in multiple months. They do not need to be consecutively, meaning the user can have a status of Fail in January, Pass in Feb, March, Apr and Fail in June. I want this included.  So basically, I'm looking to show users who repeatedly fail. 

Sample data:

Month	UserName	Status	Repeat
Jan	ASmith	Pass
Feb	ASmith	Pass
Jan	JParker	Fail
Mar	ASmith	Fail	Yes
Feb	JParker	Fail	Yes
Mar	JParker	Pass
Jan	TJones	Pass
Feb	TJones	Pass
Mar	TJones	Pass

Any help would be greatly appreciated. Thanks!

~User 900

[SpartaBI · Accepted solution]

@user900 why do ASmith has Yes? He only failed once.
Also, do you want to put yes on all the the rows of that user? or just the ones that he failed?

Take a look at this and tell me what to change:
Identifying repeating users who also meet a condition 2022-08-04.pbix

[user900]

My mistake - ASmith should not have had a Yes; he only failed once. Sorry about that. I applied your solution and it works perfectly. Thank you so much!

[SpartaBI]

@user900 my pleasure :).

P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543