Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |