Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Need help in creating a dynamic table out of the employee source data based on a particular column which has names of team leads (includes duplicates). This new table should count the ranks (text) our each employee of a team lead.
Data Source - This gets updated everyday.
Employee | Region | Country | Team Lead | Rank |
Adriana | Europe | UK | Elizabeth | EE+ |
Albert | Europe | UK | Elizabeth | ME+ |
Anna | Asia | Philippines | Elizabeth | EE |
Blaise | Americas | USA | Geraldin | EE |
Caroline | Americas | Canada | Geraldin | EE |
Cecilia | Middle East | UAE | Geraldin | NI |
Chien | Asia | Greater China | Ingrid | ME |
Dorothy | Europe | Ireland | Ingrid | ME+ |
Edmond | Middle East | UAE | Ingrid | EE |
Edwin | Europe | Scotland | Jane | EE+ |
Team Lead Table
Team Lead | EE Count | EE+ Count |
Elizabeth | 1 | 1 |
Geraldin | 2 | 0 |
Ingrid | 1 | 0 |
Jane | 0 | 1 |
Solved! Go to Solution.
@Anonymous
Okay, this is what you are looking for I think:
Employee Rank % =
DIVIDE(
COUNT(Employee[Employee]),
CALCULATE(
COUNT(Employee[Employee]),
ALLSELECTED(Employee[Rank])
)
)
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
APPRECIATE KUDOS!
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Anonymous ,
Select the column/measure you want to modify, then you will find "%" in menu bar.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Do you need to have a table created in the format you need or are you trying to show in it in a visual in the same layout?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
No, thats how my output visual should be, however i need to further calculate the % of the ranks of each TLs based on the employee strength
@Anonymous
Then you simply use a MATRIX visual and plot your fields as I did below.
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
APPRECIATE KUDOS!
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi
Its not quite what i want, although it sort of in the same directio. i want the unique Team Leads in column 1 instead of the employees and rest of the columns to give the % of count of a particular rank divided by the total number of employees of that particular team lead
@Anonymous
Okay, this is what you are looking for I think:
Employee Rank % =
DIVIDE(
COUNT(Employee[Employee]),
CALCULATE(
COUNT(Employee[Employee]),
ALLSELECTED(Employee[Rank])
)
)
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
APPRECIATE KUDOS!
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
this is perfect! how do i convert the values to %?
Hi @Anonymous ,
Select the column/measure you want to modify, then you will find "%" in menu bar.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Great! Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |