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 which has an Index Column with values 1 - 100000. I hope to link my measure CL to the Index Table in an Ascending Order. So that the lowest value of CL Measure is linked to Index 1 and so on.
| Index | CL Measure | Simulation Number |
| 1 | 213 | 33 |
| 2 | 300 | 32 |
Kindly help if possible.
Thank you.
Jimmy801 parry2k amitchandak sanalytics Anonymous
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.
3 Replies
Anonymous , Based on what I got.
With a measure like this you can use index in visual or as filter
sumx(filter(values(Simulation Number),Table[Measure] = Table2[Index]),[Measure])
As of now I treated as segmentation - https://youtu.be/CuczXPj0N-k
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.
