cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexDias Frequent Visitor
Frequent Visitor

Ranking measure needs expert opinion

Hello everyone,

 

I'm getting some wierd values which I can't understand and they aren't what I was expecting to get.

 

sales01.png

Sales02.png

I have a calculated column based in this formula:

Sales (EUR) = Sales[Amount]/ Sales[RATE EUR-USD] 

 

And my measures are:

Total Revenue = SUM(Sales[Sales (EUR)])
Rank ASC = RANKX(ALL(Sales);[Total Revenue];;ASC)
Rank DESC = RANKX(ALL(Sales);[Total Revenue];;DESC)

I can't understand the the ranking values, I was expecting to get sequencial numbers from 1 to 7 and 7 to 1 as I only got 7 different clients at my table data.

 

I can't figure what I'm doing wrong.

 

1 ACCEPTED SOLUTION

Accepted Solutions
AlexDias Frequent Visitor
Frequent Visitor

Re: Ranking measure needs expert opinion

Problem solved, I was using the table to calc the rank and not the firld that iIactualy was expecting to be ranked.

 

Solved using:

 

Rank ASC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;ASC)
Rank DESC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;DESC)

But please, if anyone has a better idea please tell.

View solution in original post

1 REPLY 1
AlexDias Frequent Visitor
Frequent Visitor

Re: Ranking measure needs expert opinion

Problem solved, I was using the table to calc the rank and not the firld that iIactualy was expecting to be ranked.

 

Solved using:

 

Rank ASC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;ASC)
Rank DESC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;DESC)

But please, if anyone has a better idea please tell.

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 341 members 3,460 guests
Please welcome our newest community members: