How do I verify the content of a column based on a number of most frequent values?

[Ante]

My goal is to create a measure that writes a 1 or 0 in a separate column.

Measure function: 

Filter out all employees from a project who are not in the same office as the project manager. In the example, employees with ID 3 and 10 would be kicked out.

Thanks in advance.

[amitchandak]

@Ante , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

You can create a histogram

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&exp=ubp8&search=hist...

https://www.youtube.com/watch?v=9kp2Nu_LuXg