Forum Discussion
Top 20 Ranking
Hi, Can someone please help me out with this one, I have searched the community and tried a number of the solutions tht have been provided but I have unfortunatley I haven't had any luck. I w...
Hi,
You may download my PBI file from here. You will see the Top 3 Pincodes by ratio in descending order. The Top 3 are obtained by a DAX measure.
Hope this helps.
Hi,
Share some data and show the expected result.
The data I am dealing with looks like
| Money In | Money Out | Postcode |
| 14000 | 19000 | 3001 |
| 13000 | 11000 | 3002 |
| 22000 | 13000 | 3003 |
| 17000 | 16000 | 3004 |
| 11900 | 11000 | 3005 |
| 15672 | 90000 | 3006 |
Expected Result
- New Ratio column ranked highest to smallest
| Money In | Money Out | Postcode | Ratio |
| 15672 | 9000 | 3006 | 1.74 |
| 22000 | 13000 | 3003 | 1.69 |
| 13000 | 11000 | 3002 | 1.18 |
| 11900 | 11000 | 3005 | 1.08 |
| 11900 | 11000 | 3005 | 1.06 |
| 15672 | 90000 | 3006 | 0.73 |
Thank you for your response
Write this measure and drag it to the visual
Measure = divide(sum(Data[Money In]),sum(Money out))
Sort this measure in descending order.
Ashish_Mathur yeah thank I have that calc sorted but how do I go about sorting them dynamically and then get a list of the top 20 in dax?
Hi,
You may download my PBI file from here. You will see the Top 3 Pincodes by ratio in descending order. The Top 3 are obtained by a DAX measure.
Hope this helps.