Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 argument".
How do I get the TOP 10 with the columns mentioned above?
@v-yangliu-msft, @amitchandak, @Ahmedx , @Ashish_Mathur
Hi,
Please follow a 5 steps process:
1. Get the Rank of NOC Colum like this:
NOC_Rank =
RANKX(
ALL(TicketData),
TicketData[NOC Completed Rate (Within 24 hours)],
,
DESC,
Dense
)
2. Get the rank of FTR column:
FTR_Rank =
RANKX(
ALL(TicketData),
TicketData[FTR Percentage],
,
DESC,
Dense
)
3. Combined the ranks:
Combined_Rank = [NOC_Rank] + [FTR_Rank]
4. Get the final rank:
Final_Rank =
RANKX(
ALL(TicketData),
[Combined_Rank],
,
ASC,
Dense
)
5. Finally, you can get a new table as follows:
Top10Table =
FILTER(
ALL(TicketData),
[Final_Rank] <= 10
)
I hope this will solve your problem.
The filter one did not work rest all worked
Hi,
Try this measure
Measure = calculate([FTR percentage],TOPN(5,all(TICKET_LIFECYCLE_FACT[FCD_FAMILYNAME]),[FTR percentage]),values(TICKET_LIFECYCLE_FACT[FCD_FAMILYNAME]))
To the visual, drag FCD Family name and this meausre.
Below is the table looking after using your DAX also, I tried to combine the RANK for two columns RANK FTR and Rank NOC Completed with DAX -
How do you expect me to help you without having access to the PBI file? Show the expected result there very clearly.
Hi @Ashish_Mathur ,
I appreciate your help I am not sure if I can share the PBX file, however, I will try to see if I can get a sample data and submit the same in PBX file
I was able to get Rank with
I tried this but getting a blank value
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |