custom fields

[surajde]

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 

custom fields table created outside using Datatable{} Dax: 

raw staffing data. 

L4 has common name for all employees but L5 has 5 different managers. they all should appear next the Staffing KPI in individual Columns for each. and numbers should be derived from below table in new datatable. 

it should be like below excel version. 

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

[Anonymous]

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.

[surajde]

@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

[surajde]

@Anonymous please share your email so that I can send you sample raw data and expected output in BI using reference tables or calculation from raw data. 

[surajde]

@amitchandak can you please help?