Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Hope you guys are doing well. I was having a problem when I try to sort Brand Name by Actual Rank. But its giving me this error:
Each brand has different but unique rank values based on Country and Brand Name combination but I am of the opinion that using a country filter should allow me to sort Brand Name using Actual Rank. I am working with a matrix because of client requirements so using a table is out of the question. I have attached both the sample excel file and pbix with this post.
Excel Data: https://1drv.ms/x/s!AjhtAEoJ85hKpVh-276QtLP_NbBL?e=dUJXQN
PBIX File: https://1drv.ms/u/s!AjhtAEoJ85hKpVlVXjWpH1B-MeXF?e=inVnIK
Any help regarding will be much appreciated.
Thanks.
Solved! Go to Solution.
no sort only takes the 2 columns into consideration nothing else. what you could do is create a composite column with rank and country and then try sort by that. if its unique it will work, but it might have performance issues if you have a lot of data, so ie concatenate rank and country into a separate field and see if that will work, not sure if there will be issues due to the calculation of rank. but give it a bash
Proud to be a Super User!
Proud to be a Super User!
Thanks for the answer @vanessafvg One thing... Does sort by column not take the filter context of country into account? Like country is included in the slicer, shouldn't it filter by country and then sort Brand Name by Actual Rank column accordingly?
no sort only takes the 2 columns into consideration nothing else. what you could do is create a composite column with rank and country and then try sort by that. if its unique it will work, but it might have performance issues if you have a lot of data, so ie concatenate rank and country into a separate field and see if that will work, not sure if there will be issues due to the calculation of rank. but give it a bash
Proud to be a Super User!
@commonsenseuser , Make you have non overlapping rank
Break ties
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
Also,You can sort a column on a column.