Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Wuebbo
New Member

Working with Count

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

NameManagerSupport 1Support 2
Michael232
Tom620
Linda301

 

My database are two Tables:

 

1. Project Overview

ProjectManagerSupport 1Support 2
A2586312
A2587121
A2588233
A2589223
A2590223
A2591212
A2592113
A2593132
A2594232
A2595312
A2596231

 

2. Employ Overview

IDName
1Michael
2Tom
3Linda

 

 

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
5 REPLIES 5
Wuebbo
New Member

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
Community Support
Community Support

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?

 

 

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

Hi @v-xuding-msft ,

 

Is it possible to upload my file?

 

Best Regards

 

Wübbo

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.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.