Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 @v-rzhou-msft
Solved! Go to 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.
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.
@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
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
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |