Indice dinamico

[Fernando232]

Hola,
Por favor quisiera ayuda para poder crear una columna que funcione como un indice dinamico en mi reporte. 

Por ejemplo esta seria mi tabla y lo resaltado el indice que quiero implementar, pero cuando cambie algun filtro, el indice tambien. 

y este seria el resultado, el indice u orden siempre empieza desde 1 en forma descendente cuando se pone cualquier filtro

[v-yohua-msft · Accepted solution]

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.

[Fernando232]

Hello @v-yohua-msft 

Hello, your answer is very good, but if there are repeated values, the index also repeats.

[Fernando232]

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.

[lbendlin]

Read about Visual Calculations and ROWNUMBER