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.
v-zhangti any idea? 🙂