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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## DAX Help - RANKX

Hi PowerBi Community!

I am having an issue with writing a DAX to create a column to rank the values of the overall sales table.

 Company 2020 Sales 2020 Rank 2021 Sales 2021 Rank 2022 Sales 2022 Rank A 10,000,000 1 10,000,000 1 7,000,000 2 B 5,500,000 2 1,500,000 4 800,000 5 C 1,000,000 4 5,000,000 2 10,000,000 1 D 5,000,000 3 1,000,000 5 1,000,000 4 E 700,000 5 3,000,000 3 5,000,000 3

The dataset I have is the problem since it shows multiply entries of Sales for each company. (Each company has 5-10 Sales entries.)

The values in the above table are total yearly Sales and PowerBI has kindly categorized and sum them for each company.

I searched online and I found solutions that asked me to use Rankx but those works for tables with only singular entries. Is there any way in PowerBi to achieve the ranking for multiple entries?

Thank you so much! Any help or alternative solution to achieve similar results will be appreciated!

1 ACCEPTED SOLUTION
Super User

@lwklwk98 , is 2020 sales is column or 2020 is year as row

You need create a measure

sales  = sum(Table[2020 sales])

Rank 2020 = rankx(all(Table[company]), [sales],,desc)

if sales is just a column same rank will work across year

2 REPLIES 2
Super User

@lwklwk98 , is 2020 sales is column or 2020 is year as row

You need create a measure

sales  = sum(Table[2020 sales])

Rank 2020 = rankx(all(Table[company]), [sales],,desc)

if sales is just a column same rank will work across year

Helper I

Thanks so much! It worked like a charm 🙂

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors