Forum Discussion
Indice dinamico
Hi, Fernando232
Thanks for the reply from lbendlin , please allow me to provide another insight:
Based on your information, I create a sample table:
You can create a measure to sort by one of your columns, and I'm just an example of how you can do it:
Index = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[EDAD])),, DESC, Dense)Regardless of the next selection, it will be sorted from 1.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Fernando232
Thanks for the reply from lbendlin , please allow me to provide another insight:
Based on your information, I create a sample table:
You can create a measure to sort by one of your columns, and I'm just an example of how you can do it:
Index = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[EDAD])),, DESC, Dense)
Regardless of the next selection, it will be sorted from 1.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
Hello, your answer is very good, but if there are repeated values, the index also repeats.
You would need a unique value anyway, in this case you can use the newly created column "order" and that would theoretically solve the problem.