Forum Discussion

admbinp's avatar
admbinp
Frequent Visitor
5 years ago

Matrix to Manage Human Resources between Projects

Hi experts,    I have to create a matrix reporting how many people in a project and how many projects a person is currently involving in.    Ideally, I expect to have a table as below:    Pr...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
HarishKM's avatar
HarishKM
Icon for Super User rankSuper User
5 years ago

admbinp  Hey 

drag that project id (if data type is text ) and employee in matrix row coloumn then drag your unique employee id  = countrows(employee_id) once you will do you will find like this .

when you select distinctcount then for row it will show only 1 at total but for col you will get correct result but if you will use countrow then you will have the sum at both level .


Pasting image for your ref.

Left with disticnt count and right with countrows.

 

 

 

 

unique record = COUNTX(financials,DISTINCTCOUNT(financials[Product]))