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

How can I use Sort by Column and RANKX at same time.

Hi all,

 

I used RANKX to set up my Power BI report before. But today I got some problems when using RANKX and Sort by Column function at the same time. I really need you help, I really appreciate that.

 

This is my test data, Product is sort by Product as normal

 

These are 2 measures to test data:

 

 

test_c = CONCATENATEX(ALL(test[Product]),CALCULATE(SUM(test[Qty])),,",",ASC) 

 

 

 

 

test_r = RANKX(ALL(test[Product]),CALCULATE(SUM(test[Qty])),,ASC) 

 

 

The result looks well. But I want to sort Product by column "Sort" 

 

After that when I come back to my 2 measures, it's give wrong number. I dont know why?

I did research a lot around to this problem, but I still did not get the answer. Did anyone get into this situation before, how can I solve this problem?

 

Thank you all

 

bir1concepts_1-1622098441762.png

bir1concepts_3-1622098625040.png

bir1concepts_0-1622098221671.png

bir1concepts_2-1622098493311.png

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@bir1concepts , Try Rank like

test_r = RANKX(ALL(test[Product], test[Sort),CALCULATE(SUM(test[Qty])),,ASC)

 

Same way you can try for another measures



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
bir1concepts
Frequent Visitor

Thank @amitchandak a lot, you saved my day ❤️

amitchandak
Super User
Super User

@bir1concepts , Try Rank like

test_r = RANKX(ALL(test[Product], test[Sort),CALCULATE(SUM(test[Qty])),,ASC)

 

Same way you can try for another measures



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!