Forum Discussion
custom fields
Hi all, Need help with all below customer fields that do not have any direct relation with Employee data but it is summary. Somehow I'm not able to populate numbers against these fields ...
Hi surajde ,
I can't understand you correctly. please provide more details with your desired output and pbix file without privacy information (or some sample data).
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
I have created Datatable using below dax for my custom values that are not present in the raw data.
Scorecard = DATATABLE("SrNo",INTEGER,"Priority",STRING,"Staffing KPI",STRING,"Type",STRING,"Target",DOUBLE,{
{1,"","Total Staff","",Blank()},
{2,"Hiring Cycle","Senior (Ex Director)","LT",0.05},
{3,"Correction","People Managers","LT",0.2},
{4,"Correction","Non Managerial","GT",0.75},
{5,"Hiring cycle","Graduate","GT",0.05},
{6,"Renewal cycle","Expat","LT",0.02},
{7,"Hiring cycle","Employee","GT",0.9},
{8,"Hiring cycle","Contractor","LT",0.9},
{9,"Correction","Veterans in same role for 5+ years","LT",0.2},
{10,"Correction","Same Role/Seniority reporting","EQ",0},
{11,"Correction","Team Leads with LT 2 emps","EQ",0},
{12,"Correction","Managers with LT 5 emps","EQ",0},
{13,"Hiring cycle","Gender Diversity - Female population","GT",0.3},
{14,"Correction","Staff at approved locations (DLS, ATL, Mx, IND, STL)","GT",0.9},
{15,"Correction","Working from home","LT",0.05},
{16,"Tracking","Customer site","",0},
{17,"Tracking","Senior Non Manager","",0}
})
Reference Tables:
For count of People manager Use below reference.
Employee Managerial Type
| Manager of Managers |
| Manager |
| Manager of Org |
for Senior Ex Director count use below reference
| Role | Employee Role Seniority |
| Solution Integration & Implementation Line Manager | One level of Seniority |
| Services Business Leader | Experienced |
| Program Manager | Experienced |
| Technologies Line Manager | One level of Seniority |
| Software Engineering Line Manager | One level of Seniority |
| Service Delivery Lead | Advanced |
| Software Architect | Advanced |
using this I should get count against each L4 or L5 manager as shown in the last image of the original post.
it should be like below
| SrNo | Staffing KPI | L4 Manager | L5 Manager 1 | L5 Manager 2 | L5 Manager 3 | L5 Manager 4 | L5 Manager 5 |
| 1 | Total Staff | 240 | 98 | 45 | 41 | 46 | 10 |
| 2 | Senior (Ex Director) | 15 | 4 | 3 | 5 | 2 | 1 |
| 3 | People Managers | 35 | 10 | 15 | 5 | 3 | 2 |
| 4 | Non Managerial | ||||||
| 5 | Graduate | ||||||
| 6 | Expat | ||||||
| 7 | Employee | ||||||
| 8 | Veterans in same role for 5+ years | ||||||
| 9 | Same Role/Seniority reporting | ||||||
| 10 | Managers with LT 5 emps | ||||||
| 11 | Team Leads with LT 2 emps | ||||||
| 12 | Gender Diversity - Female population | ||||||
| 13 | Staff at approved locations (DLS, ATL, Mx, IND, STL) | ||||||
| 14 | Working from home | ||||||
| 15 | Customer site | ||||||
| 16 | Senior Non Manager |