Forum Discussion
Table based on TOP N Selection
Hello.
Is this possible to achieve in Power Bi?
Set a TOP N items by sales.
From the TOP N item selection, a table will show each salesperson how if they sold or which of the TOP N items they sold and to which customers with sales value.
Please see illustration below for details. Thanks.
4 Replies
Hi,
You should rag this measure to your second visual
=calculate([sales],topn(5,all(data[itemno]),[sales]),values(data[itemno]))
Hope this helps.
Hi Ashish,
The measure is just created. What exactly do you mean by rag this measure? Does it need to be in a filter?
Thanks.
Hi,
From the second visual that you have shared in your post, remove the Sales measure and drag this new measure.
Hi Oros ,
This blog can help you:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
