Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Anshenterprices
Helper IV
Helper IV

Calculate Ranking and percent ranking


Hi Team.

 

DateCategoryOnline offline1DaySalesRankpercent rank
4/6/2021EquityOnline1234100
4/6/2021EquityOnline345375
4/6/2021Equityoffline567250
4/6/2021Equityonline789125
4/6/2021Commodityonline4532100
4/6/2021Commodityoffline564150
4/6/2021Currencyonline2341100
4/5/2021Equityonline256375
4/5/2021Equityonline04100
4/5/2021Equityonline345250
4/5/2021Equityoffline754125
4/5/2021Commodityonline6831100
4/5/2021Commodityonlinenull  
4/5/2021Currencyonline2463300


I want to calculate rank and percent rank

In report i have slicer Date, Category, Online offline 

Ranking is based on 1daysales by the selection of date and category 
percent rank forumula= ranking*100/counta(1daysales)

Note :- if its blank dont assign rank and percent rank also once i select online or offline category slicer, dont want seperate raking and percent rank , it should be same in both ways.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anshenterprices , Please find the attached file after signature. The last row is a bit different 

 

Check the table in data view

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anshenterprices , Please find the attached file after signature. The last row is a bit different 

 

Check the table in data view

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Awesome ! @amitchandak  Thank you so much 

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.