Forum Discussion
Calculated column to rank data based on the filter context
Hello, Is it possible to create calculated column to rank the data based on the filter context? I have in the database column Dataset_1, Dataset_2 ... . Each Dataset_ contain 5 different quarters...
Hi, Anonymous
You can try the following methods.
Order = RANKX(FILTER('Table 2',[Dataset]=EARLIER('Table 2'[Dataset])&&[Phase]=EARLIER('Table 2'[Phase])),[%],,ASC)Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I hope it make it more clear.
More less user select Dataset 1 or 2, based on that he see in the table appropriate Quaters.
Based on that quters he see in the table appropriate % values from the table.
v-zhangti
Community Support
Community SupportHi, Anonymous
You can try the following methods.
Order = RANKX(FILTER('Table 2',[Dataset]=EARLIER('Table 2'[Dataset])&&[Phase]=EARLIER('Table 2'[Phase])),[%],,ASC)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.