Forum Discussion
Ranking Issues
1.Hi Folks, I am using source is tabular cube. How we build the cube we are calling all facts in view(Main FactTable) and connect with Dimenssions. Now my view producing 800000(8 lakhs) records so w...
Anonymous
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.