Forum Discussion

manojk_pbi's avatar
manojk_pbi
Helper V
3 years ago
Solved

Top N in table with multiple columns

Hi Friends,   I am looking for a suggestion or solution on how to create a table with Top N Customers on sales with other details of customer in the table. Top N can be on entire data or it can be ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

manojk_pbi's avatar
manojk_pbi
Helper V
3 years ago
Hi Rico Zhou, Thanks for quick reply. Do we have option to pick always top N irrespective of repeated value with out any condition ? When I select Top 2 or 3 the result remains same for Product1.
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • manojk_pbi's avatar
    manojk_pbi
    Helper V
    3 years ago
    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.