Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Query

I am trying to write a dax query to calculate percentile for a value in a sub-group. Below is my query. When I run it the field for  Employee Percentile Rate  returns blanks.   Employee Perc...
Need Help
Show and Tell
Tutorial Requests
mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

sorry for the misunderstanding, but I need to know which are your expected values in Column [Employee Percentile Rate]. Can you send us a sample table?

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Service LineIncentive PoolEmployee IDFirst NameLast NameEligibility FactorEmployee Percintile Score
Customer Account ServicesCAS001BSE123037EricBurton3.75 
Customer Account ServicesCAS001BSE083568JamesOntiveros4.63 
Customer Account ServicesCAS001BSE095868JamesSt. Julien4.25 
Customer Account ServicesCAS001BSE130370JamesDiep3.76 
Customer Account ServicesCAS001COE127667JamesArtiga3.82 
Customer Account ServicesCAS001ICE115243JamesAdelakoun4 
Customer Account ServicesCAS001ICE112434JamesMenefee - PWE4.5 
Customer Account ServicesCAS001ICE113468JamesHughes4.75 
Customer Account ServicesCAS001ICE090711JamesVincent3.88 
Customer Account ServicesCAS001MRE169863JamesMcDonald4.88 
Customer Account ServicesCAS001MRE118293JamesNguyen4 
Capital ProjectsCIP001CPE160779RobertCarpy4.46 
Capital ProjectsCIP001CPE155001RobertBurroughs4.5 
Capital ProjectsCIP001CPe172462RobertAl Amari3.76 
Capital ProjectsCIP001CPe137368RobertHall4.25 
Capital ProjectsCIP001CPE167678RobertSanders3.88 
Capital ProjectsCIP001CPE168042RobertPatankar4 
Capital ProjectsCIP001CPE150729RobertDedeaux4.01 
Capital ProjectsCIP001CPe168057RobertLee4.75 
Capital ProjectsCIP001CPE174429RobertBurrell4 
Capital ProjectsCIP001CPE128238RobertO'Briant3.75 
Capital ProjectsCIP001CPE137141RobertWatson4 
Capital ProjectsCIP001CPE154894RobertCantu4.25 
Capital ProjectsCIP001CPE173676RobertGillespie4 
Capital ProjectsCIP001CPE168593RobertMcKee5 
Capital ProjectsCIP001CPE172387RobertPonton4 
Capital ProjectsCIP001CPE140164JohnDavidson3.75 
Directors OfficeDIR001LDE110055JohnLopez3.75 
Directors OfficeDIR001LDE123033JohnVuong3.76 
Directors OfficeDIR001LDE079892JohnAllen4.12 
Directors OfficeDIR003IRE139390JohnLuckenbach4 
Directors OfficeDIR003IRE166102JohnNelson4.67 
Directors OfficeDIR003IRE136984JohnWilson4.12 
Directors OfficeDIR006ITe167581JohnHussain3.75 
Directors OfficeDIR006ITe167935JohnMarcano4.58