Forum Discussion
group ranking
Hi Valerica_G ,
Please check the measures below.
Measure = SUM('Table'[stock]) rank = RANKX(ALLSELECTED('Table'[region]),[Measure],,DESC)Result would be shown as below.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Valerica_G ,
Honestly, I'm not sure what you want.
Are you want to rank 1 to 3 for the 3 regions that have a very high stock and 1 to N for the others? And then distinguish them by red and green?
Could you please share some sample data and expected result if you don't have any Confidential Information?
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the answer Anonymous
So lets say we have some sample data
date | region | province | stock |
2020-01-01 00:00 | A | X | 5 |
2020-01-01 00:00 | A | Y | 10 |
2020-01-01 00:00 | B | Z | 1000 |
2020-01-01 00:00 | B | W | 300 |
2020-01-01 00:15 | C | k | 12 |
2020-01-01 00:15
| C | l | 44 |
2020-01-01 00:15
| D | m | 20 |
| 2020-01-01 00:15 | D | n | 14 |
And I have some filters, on date or other columns (like product, severity etc.). I want to summarize this filtered stock by regions and then rank them by this value.
If the sample data are my filter results then the rank will be something like that:
region | stock
| rank |
A | 15 | 4 |
B | 1300 | 1 |
| C | 56 | 2 |
| D | 34 | 3 |
So if I set in put in the chart color saturation by sum of stock the map will be red on 3 region and green just in one because the difference between the first one and the second are very big. If I put color saturation by this rank that I don't know how to calculate in power bi then all 4 regions will have a distinct color something like green, yellow, orange, red. This way I can see the differences between the smaller regions more clearly.
On the real data I want to rank them from 1 to n (number of regions) and the map will be something like that, each region with a different shade representing that rank. I did this map by aggregating them in the database and rank that, but this does not help me because I need to be able to change filters before aggregation.
Hi Valerica_G ,
Please check the measures below.
Measure = SUM('Table'[stock]) rank = RANKX(ALLSELECTED('Table'[region]),[Measure],,DESC)Result would be shown as below.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.