Forum Discussion
sort index
Hi netanel ,
Difficult to explain this error message. One simple solution is that we had better go back to create measure😑. But sort by column function is only useful to columns, so a potential solution is that put the measure in the visual and click the three dots(...) on the right corner of this visual, use sort by in the visual by the measure or description as I previous mentioned.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi netanel
for Index columns you can use 2 ways:
1. Add Index column in Power QUery mode
2. Add RANKX() columns. Complete guide to use use RANKX you can find here https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
1. I know really well the problem is that he gives a different number to the same description.
2. It is excellent, but I have a different description that is not perceived in ranks.
So I'm still stuck...
A 1
A 1
A: 2
B 3
this is how its need to look like
Hi netanel ,
Is this your expected result?
If so, try to create a calculated column like this:
Column = RANKX ( 'Table', 'Table'[Column A],, ASC, DENSE )Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hey,
This formula is exactly what I use
But it brings me the next result
"A single value for column 'תיאור' in table 'Report (2)' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
I think it's because iam trying to create a measure instead of a calculated column.
still stuck...
Hi netanel ,
That's right. This fomula will only work with a calculated column.
If you want to create a measure, try this formula:
Measure = RANKX ( ALL('Table'), CALCULATE(MAX('Table'[Column A])),, ASC, DENSE )But it will only show a single value in the table visual because table visual will not show repeated value of one column if there is not any other field in the table visual.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.