Forum Discussion
Ranking Issues
Community ChampionAnonymous
It is possible. Refer to this link.
https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/
If you can share the sample data, then we can try that.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Hi Please find the below sample data.
State licence came from Table A
Provider Legacy Number, Provider name came from Table B
Paid Amount, Total claim services, Unique patients,# of service Came from Table3 Fact(This all are sum), Now i want to display Top 50 records based on paid amount. Please let me know if you need any information.
- nandukrishnavs
Anonymous
Can you share the data in a table format (Not image)? Or in an excel file? You can mask your confidential data and share few rows and expected output.
Hi Please find the sample data, Rankx should be created as calucalted measure not index column becacuse my source is tabular model so i can't create index column or Generateseries function.
https://drive.google.com/drive/u/0/folders/1PCfqXc90S4qFg374-GxIo-5uh2YoF8NC
- nandukrishnavs
Anonymous
I don't have access