Filtering a user field based on a condition

[ToGM]

In my report I have a list of employees which are used in a slicer and data visuals.  This report has data spanning over many years, and to emphasize relevancy, we want to only see employees who had x amount of jobs worked on during the selected time period. 

The logic would be something like: if employee worked 5+ jobs, show name, else show "Other"

 How can I create a dynamic measure/column which can group employees into the "Other" category based on data from another table?

[v-cgao-msft]

Hi @ToGM ,

The calculated column is recalculated when the memory is refreshed, and it cannot interact with the slicer.

You can create a measure like this one and put it into a visual filter to dynamically filter it.

Measure = IF( DISTINCTCOUNT('Table'[Job Categories]) >= 5, MAX('Table'[Employee ID]))

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum