Forum Discussion
jacosmit
7 years agoRegular Visitor
Filter in DISTINCTCOUNT question
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 |
1 Reply
- themistoklis
Community Champion