Working with Count

[Wuebbo]

Hy,

my name is Wübbo and I use the first time PowerBi. In the past I get some skills to Work with Excel, but I see, that PowerBi ist different. 

Ok, why I am hear:

I want to Create a Matrix with four Columns like in this Example:

Overview of the Projects for each Employee

Name	Manager	Support 1	Support 2
Michael	2	3	2
Tom	6	2	0
Linda	3	0	1

My database are two Tables:

1. Project Overview

Project	Manager	Support 1	Support 2
A2586	3	1	2
A2587	1	2	1
A2588	2	3	3
A2589	2	2	3
A2590	2	2	3
A2591	2	1	2
A2592	1	1	3
A2593	1	3	2
A2594	2	3	2
A2595	3	1	2
A2596	2	3	1

2. Employ Overview

ID	Name
1	Michael
2	Tom
3	Linda

I have no Idea how i can great this visual withe PowerBi and I try it for 5 Days, so I would be glad I someone please give my an hint 😉

Thanks 

Wübbo

[Wuebbo]

Thanks a lot,

It works i am so glad.
I use the Dax "USERELATIONSHIP" to count the specific members. 

Again, thanks to evereyody for the help.

[v-xuding-msft]

Hi @Wuebbo ,

I'm a little confused about your sample data. Can you please share the computing logic with us? Is the Employ ID same as 1,2,3 in Projects? How do we count the Manager, Support 1 and Support 2 for each Employee?

[Wuebbo]

Hi @v-xuding-msft ,

Is it possible to upload my file?

Best Regards

Wübbo

[v-xuding-msft]

Hi @Wuebbo ,

You could upload a sample into OneDrive for Business. And then share the link with us. Thanks!

Note: Please share a sample rather your actual file. If there is any sensitive data, please replace them with others.

[amitchandak · Accepted solution]

@Wuebbo , option one is to unpivot first table and join withs Second

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose: https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Option 2 is to join table 1 to table 2, three times, one active and 2 inactive join. create three measure and use userelation in 2 measures

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...