Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
kolturra
Helper IV
Helper IV

RANKX DAX for same category and same total in multiple rows

‎11-12-2019 02:41 AM

Hi,

 

I have below data and want to RANKX with our grouping , can some one please help me with DAX.

 

Student NamePassPercentage
AbhiRam64%
AbhiRam64%
AbhiRam64%
Adithya Vikram Singh More68%
Adithya Vikram Singh More68%
Adithya Vikram Singh More68%
Aditya88%
Aditya88%
Aditya88%

 

Thanks,
K Raghavender Rao

Message 1 of 4
437 Views
0
1 ACCEPTED SOLUTION
kolturra
Helper IV
Helper IV
In response to kolturra

‎11-13-2019 01:01 AM

Hi,

 

Found the answer myself. Thanks for your support.

 

Thanks,

K Raghavender Rao

View solution in original post

Message 4 of 4
382 Views
0
3 REPLIES 3
amitchandak
Super User
Super User

‎11-12-2019 03:15 AM

Column =
RANKX (
'Table',
passpercent, // or average(passpercent)
,
DESC,
DENSE
)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 4
431 Views
0
kolturra
Helper IV
Helper IV
In response to amitchandak

‎11-12-2019 04:51 AM

Hi,

 

Below is the error what i can see.

 

Thanks,

RRFile.png

Message 3 of 4
391 Views
0
kolturra
Helper IV
Helper IV
In response to kolturra

‎11-13-2019 01:01 AM

Hi,

 

Found the answer myself. Thanks for your support.

 

Thanks,

K Raghavender Rao

Message 4 of 4
383 Views
0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All