Forum Discussion
Solved
Show Top 10 Score in the table
Hi, Top 10 Sorting my data in the total score column on the table is somewhat challenging for me. 😞 The table does not have any unique column values, but there are duplicates in the Subdivision a...
Hi,
PBI file attached.
Hope this helps.
Anand24
Super User
Super UserPowerBiTech ,
You need a unique rank field. Check the solutions of the below community queries and these should definitely help:
https://community.fabric.microsoft.com/t5/Desktop/Remove-Duplicate-Ranking/td-p/1150591
https://community.fabric.microsoft.com/t5/Desktop/Power-BI-unique-Rank/td-p/1557656
Hi Anand24
Thanks for sharing.
In My case no data is unique in my table list. If you check in the Sub division column "AURORA" is duplicate and in top 10 list two times present. I cant be able to calculate the formula based on that column. Above mentioned example are depands on unique month or unique product. for my senario its quite diffrent.