Forum Discussion
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 and Total score.
The end outcome must consist of the descending value of the top 10 in the table.
Yellow Box results should be needed . Please suggets to get that.
Attaching the PBIX file here SampleFile.pbix
TIA 🙂
@Greg_Deckler @Ritaf1983 @lbendlin @Ashish_Mathur @ryan_mayu @danextian @_AAndrade @audreygerred @rajendraongole1 amitchandak lbendlin Anand24 Arul johnbasha33 Kaviraj11 bhanu_gautam
Hi,
PBI file attached.
Hope this helps.
5 Replies
- Anand24
Super User
PowerBiTech ,
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/1150591https://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.
- Ashish_Mathur
Hi,
Share the file over some other file hosting service. MS Edge classifies that site as unsafe.
I have updated the uploaded path and the link is here google drive link for power bi file .
Thank you
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.
