custom fields

Question

Hi all,&nbsp;&nbsp;Need help with all below customer fields that do not have any direct relation with Employee data but it is summary.&nbsp;Somehow I'm not able to populate numbers against these fields&nbsp;custom fields table created outside using Datatable{} Dax:&nbsp;&nbsp;raw staffing data.&nbsp;&nbsp;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.&nbsp;&nbsp;it should be like below excel version.&nbsp;SrNoStaffing KPIL4 ManagerL5 Manager 1&nbsp;L5 Manager 2L5 Manager 3L5 Manager 4L5 Manager 51Total Staff24098454146102Senior (Ex Director)15435213People Managers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4Non Managerial&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5Graduate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6Expat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7Employee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8Veterans in same role for 5+ years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9Same Role/Seniority reporting&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10Managers with LT 5 emps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11Team Leads with LT 2 emps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12Gender Diversity - Female population&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13Staff at approved locations (DLS, ATL, Mx, IND, STL)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14Working from home&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15Customer site&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16Senior Non Manager&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

surajde · Answer

amitchandak&nbsp;can you please help?&nbsp;

anonymous · Answer

Hi&nbsp;surajde&nbsp;,
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&nbsp;
&nbsp;
Best RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;

surajde · Answer

Anonymous&nbsp;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.&nbsp;

surajde · Answer

Anonymous&nbsp;I have created Datatable using below dax for my custom values that are not present in the raw data.&nbsp;Scorecard = DATATABLE("SrNo",INTEGER,"Priority",STRING,"Staffing KPI",STRING,"Type",STRING,"Target",DOUBLE,{&nbsp; &nbsp; {1,"","Total Staff","",Blank()},&nbsp; &nbsp; {2,"Hiring Cycle","Senior (Ex Director)","LT",0.05},&nbsp; &nbsp; {3,"Correction","People Managers","LT",0.2},&nbsp; &nbsp; {4,"Correction","Non Managerial","GT",0.75},&nbsp; &nbsp; {5,"Hiring cycle","Graduate","GT",0.05},&nbsp; &nbsp; {6,"Renewal cycle","Expat","LT",0.02},&nbsp; &nbsp; {7,"Hiring cycle","Employee","GT",0.9},&nbsp; &nbsp; {8,"Hiring cycle","Contractor","LT",0.9},&nbsp; &nbsp; {9,"Correction","Veterans in same role for 5+ years","LT",0.2},&nbsp; &nbsp; {10,"Correction","Same Role/Seniority reporting","EQ",0},&nbsp; &nbsp; {11,"Correction","Team Leads with LT 2 emps","EQ",0},&nbsp; &nbsp; {12,"Correction","Managers with LT 5 emps","EQ",0},&nbsp; &nbsp; {13,"Hiring cycle","Gender Diversity - Female population","GT",0.3},&nbsp; &nbsp; {14,"Correction","Staff at approved locations (DLS, ATL, Mx, IND, STL)","GT",0.9},&nbsp; &nbsp; {15,"Correction","Working from home","LT",0.05},&nbsp; &nbsp; {16,"Tracking","Customer site","",0},&nbsp; &nbsp; {17,"Tracking","Senior Non Manager","",0}&nbsp; &nbsp; })&nbsp;&nbsp;Reference Tables:For count of People manager Use below reference.&nbsp;&nbsp;Employee Managerial Type Manager of ManagersManagerManager of Org&nbsp;for Senior Ex Director count use below referenceRoleEmployee Role SenioritySolution Integration &amp; Implementation Line ManagerOne level of SeniorityServices Business LeaderExperiencedProgram ManagerExperiencedTechnologies Line ManagerOne level of SenioritySoftware Engineering Line ManagerOne level of SeniorityService Delivery LeadAdvancedSoftware ArchitectAdvanced&nbsp;using this I should get count against each L4 or L5 manager as shown in the last image of the original post.&nbsp;&nbsp;it should be like below&nbsp;SrNoStaffing KPIL4 ManagerL5 Manager 1&nbsp;L5 Manager 2L5 Manager 3L5 Manager 4L5 Manager 51Total Staff24098454146102Senior (Ex Director)15435213People Managers3510155324Non Managerial&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5Graduate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6Expat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7Employee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8Veterans in same role for 5+ years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9Same Role/Seniority reporting&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10Managers with LT 5 emps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11Team Leads with LT 2 emps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12Gender Diversity - Female population&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13Staff at approved locations (DLS, ATL, Mx, IND, STL)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14Working from home&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15Customer site&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16Senior Non Manager&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

custom fields

4 Replies

Related content

Emty row in custom field

Planner Tasks Custom Fields in Dataverse

Field Parameter Question

Customer Scorecard

Custom Visual

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

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