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 want to be able to rank percentages that Im looking at against Month and Group. The following shows the info in a simple table (With the rank I want) but I will be putting it into a matrix with Month and Columns
Jan | Group 1 | 89% | 1 |
Jan | Group 2 | 60% | 2 |
Jan | Group 3 | 55% | 3 |
Feb | Group 1 | 90% | 2 |
Feb | Group 2 | 99% | 1 |
Feb | Group 3 | 60% | 3 |
Mar | Group 1 | 50% | 3 |
Mar | Group 2 | 80% | 1 |
Mar | Group 3 | 70% | 2 |
I have used the following DAX but its ranking everything as 1
Solved! Go to Solution.
Hi @DebbieE ,
To create a measure as below.
Measure = RANKX(ALLEXCEPT('Table','Table'[month]),[Avg Overall satisfaction],,DESC,Dense)
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
I have added this in as rank2 and it doesnt seem to work The DAX I used (Rank) works fine in a table (If I omit Null values)
Here is a picture of both ranks in action
Unfortunately I cant upload my files to One Drive.
Try using :
Ive had a go
I cant SUM my AVG Overall Satisfaction. Parameter is not the correct type. Its already averaged in a measure so I changed it to this
I have almost got it working
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |