If slicer filters client then it should show other project and employees related to project.

[Data87]

 This may require new Dax metrics, The focus here is that you can select any particular client, and show based on the selected client, what other projects/clients the employees have been working on. It would be nice to show the rank of the client against others based on a selectable metric the user can pick from a slicer or button. How to calculate using dax

[foodd]

How to Get Your Question Answered Quickly 

Please provide more details with your desired output and work-in-progress Power BI Desktop file without privacy information so that members of the Forum may better understand the state of the model, relationships, visuals,
and any measures applied.

[v-rongtiep-msft]

Hi @Data87 ,

Could you please provide more details?

How to Get Your Question Answered Quickly 

Please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Data87]

Like if we select client in slicer then it should show other clients details