Forum Discussion
Top N in table with multiple columns
Hi manojk_pbi ,
As above I add a rank in my calculation, so if you want to show TOP N in another way, we need to add some condtions in my code to create new rank.
You can show me a screenshot with the result you want as Product Top2 and Top3, I will try to find the condtion to help you solve your issue.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi manojk_pbi ,
The second value is 16, however there are three data as 16 in Product 1, all of them will be marked as second one.
If you want to sort these three data with same value 16, you need a new condtion like title sort or others. Please tell me more details.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi manojk_pbi ,
As above I add a rank in my calculation, so if you want to show TOP N in another way, we need to add some condtions in my code to create new rank.
You can show me a screenshot with the result you want as Product Top2 and Top3, I will try to find the condtion to help you solve your issue.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- HI Rico Zhou, I created new column with RAND() function and used it in RANK Measure. It is working as expected. Thanks for the solution and advise.