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.
Hello,
I did a report with a table that ranks several brands my company sells, based on each brand income.
I would like to add a first column with the line numbers (ranking).
Is there a way to do so?
Thanks in advance
Jo
Solved! Go to Solution.
Hi @Jo_Chrq ,
You can also try
RANK = RANKX(ALL('Table'[Regions ],'Table'[Stores ]),CALCULATE(SUM('Table'[Revenue ])))
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
@Jo_Chrq , are you looking for serial no of line ?
Not there. You have to use Rank if possible. Vote for the idea -https://ideas.powerbi.com/ideas/idea/?ideaid=80612ec5-14a9-4929-a2ee-531943fa51d4
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Hi @amitchandak
Yes believe that's it.
If you consider the following table, I have the columns "Stores" and "Revenue" and basically I need to add the Rank column :
Rank (column needed) | Stores | Revenue |
1 | Store B | 100€ |
2 | Store C | 95€ |
3 | Store A | 75€ |
Hi @Jo_Chrq ,
Create these 2 measures
Total Sales = SUM('Table'[Revenue])
RANK = RANKX(ALL('Table'[Stores]), [Total Sales],,DESC)
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Thank you, I'm now getting really close but still have an issue.
The table actually has an extra column and the ranking I get is within these categories (btw I apologize for my poor English level ...)
Here's the result I get :
Rank | Regions | Stores | Revenue |
1 | North | Store B | 100€ |
2 | North | Store C | 95€ |
1 | South | Store A | 75€ |
3 | North | Store F | 60€ |
2 | South | Store D | 55€ |
I would like to have the overall ranking, regardless the regions ...
Many thanks again
Hi @Jo_Chrq ,
RANK = RANKX(ALL('Table'),CALCULATE(SUM('Table'[Revenue ])))
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @Jo_Chrq ,
You can also try
RANK = RANKX(ALL('Table'[Regions ],'Table'[Stores ]),CALCULATE(SUM('Table'[Revenue ])))
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @Jo_Chrq ,
Please share additonal details on your query. This is not helping at all.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks,
Pragati
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |