Showing common values ?

[camillebabz]

Hello,

I've got 2 tables : T_society (with a unique number for each society) and T_Employees (with : name - and the n° of the society where the personn work).
Someone can work in mutiple societies so they appear multiple times in the table with, each time, the n° of the society.
I would like to have a matrix with all the names of the society on the left side and same on the top of the matrix.

When there is a similear worker between two societies, having a "yes" that show up in the matrix to show the "link" between two societies. Is it possible ?

Thank u !

[camillebabz]

Hi @v-yalanwu-msft ,

Here an example of my tables :
T_Society :

T_Employees :

The Result :

So, there is a common employee between A and D : so we can see that link between them two.
But I can't find how to made that automatically in PowerBi. The only result I have is if I have the details of my employees on the left. But my matrice is too big. I wan't a "resume" of that. If one ore more work in 2 societies : put a yes, but not the details of all the employees. I don't know if its very clear.

Here an example of my result on Power Bi :
On the top : the name of the societies
On the left : name of the employees

I juste want to have societies on the left of the matrix and "resume" the fact that : it's one or more employee work in society A and society B : but a "Yes" and not have de details like in me results

Thank u !

[v-yalanwu-msft]

Hi, @camillebabz ;

Can you share a simple example and hopefully output the results for easier purposes?

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.