Indexing a Measure

[Anonymous]

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 

[Anonymous · Accepted solution]

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.

[amitchandak]

@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

[Anonymous]

Hello Amit, thank you for taking the time to reply.

I may be missing something, but was not able to understand your formula. I do not understand what Table[Measure] refers to.

Please clarify if possible.

Thanks