Filter in DISTINCTCOUNT question

[jacosmit]

New to the forum.

Snippet of db below.

Using Powerbi I would like to figure out how many staff ate at the restaurant. But I only want them to be counted if they ate at the restaurant more than 5 times during the month. (There are 100's of staff member so DISTINCTCOUNT would need to be part of the measure) 

Any help appreciated

User_ID	Meal	Month
Joe Soap	Main 1	October
Joe Soap	Main 1	October
Joe Soap	Main 1	October
Joe Soap	Main 4	October
Joe Soap	Main 5	October
Cathy Black	Main 1	October
Cathy Black	Main 1	October
Cathy Black	Main 2	October
Cathy Black	Main 3	October
Cathy Black	Main 4	October
Stewart Little	Main 5	October

[themistoklis · Accepted solution]

@jacosmit

Create a new measure using the following formula

Measure = DISTINCTCOUNT(Table[Meal])

Then create a table and add UserID, Month as Dimensions and the measure.

See workspace on this link

Also you can use the filter pane to filter those who ate more than 5 times