Forum Discussion
saud968
Memorable Member
Memorable MemberTop 10 with Multiple Columns
I have multiple columns and I am trying to get the dynamic top 10 with NOC Completed Rate and FTR Percentage, however, while creating RANKX Dax is getting an error "special flag is not allowed as an ...
saud968Memorable Member
Memorable MemberI was able to get Rank with
Rank NOC Completed = RANKX(ALL(TICKET_LIFECYCLE_FACT[FCD_FAMILYNAME]), [FTR PERCENTAGE],,DESC)
Struggling on Top 10 DAX, please help
Struggling on Top 10 DAX, please help
saud968Memorable Member
Memorable MemberI tried this but getting a blank value
Top N by Family Name =
var selected_top = SELECTEDVALUE(TICKET_LIFECYCLE_FACT[FCD_FAMILYNAME])
var top_fam = SWITCH(selected_top, "Top 5" , IF([Rank FTR] <=5, [FTR PERCENTAGE]) )
return top_fam
not sure if the above is corrected