Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Data Protection
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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