Forum Discussion
Indexing a Measure
Hello! I have a meaure called CL which has distinct vaues to a respective Simulation Number. Simulation Number CL Measure 32 300 33 213 I have another table called Index wh...
Hi Anonymous ,
Measure is dynamic, and the table is fixed, so the Measure cannot establish a relationship with the table.
You can use the RANKX function.
Index = RANKX(ALL('Table'),CALCULATE([CL Measure]),,ASC,Dense)Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Measure is dynamic, and the table is fixed, so the Measure cannot establish a relationship with the table.
You can use the RANKX function.
Index = RANKX(ALL('Table'),CALCULATE([CL Measure]),,ASC,Dense)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.