20 stores (sites)
2 million sales lines.
I already made a ranking of my customers prs site (but i suspect I will have to do something different) :
' Customer top X = IF ( ISINSCOPE('Customer'[C_No+Name]), RANKX ( CALCULATETABLE ( VALUES ('Customer'[C_No+Name]), ALLSELECTED ( 'Customer'[C_No+Name]) ), ['Amount] ) )
If i make a matrix and have store name as top row and C_No+Name] as 2. row and add the " ' Customer top X" as value i get a nice show of all stores, and all customers ranked based on Amount - Now i add a filter and show only " ' Customer top X"<11 and i have a top 10 pr store.
Now i however wanted a top 10 items pr customer pr. site - and no matter how i twist and turn it... (besides getting it to be really slow) I cant make this happen.
im thinking something like:
|1 of 10||1||Customer YY||Item 1||100||24||1|
|2 of 10||1||Customer AA||Item 1|
|Rank pr store||Item 1||item 2||item 3||Item 4||Item 5||Item 6||Item 7||Item 30|
For Rank Refer these links
@amitchandak - did you read what I wrote or did yo just spam external sites with becaseu you have a bot that searches for keywords?
you are linking to the excat solotion i have already done my self, its the next part of the problem i want help to do.
@Rygaard , My understanding was you need the top 10 items per customer. That is what I shared the links. Can you share raw data and final output in a table format and crisp problem description? One can get lost in a big description.
Performace has two aspects when data is big, If you create a column it will increase load time, If you create it as a measure it may increase visual display time. Depend on power BI desktop/service hardware, performance may vary
@amitchandak - yes sorry but it seems alot will post links to what I have already acomplished not only here but in general, perhaps i Need to work on my writing skills.
I have a customer top 10 pr. site.
now i would like a item top 10 for each of thouse top 10 customers, for each site.
so it is a top 10 items pr customer (that is in the former top 10). for each site.
Hi @Rygaard ,
See if this article helps you.
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
you are linking to the only part I have already done - I got that part done.
its the next part that is hard
I have a top X (rankX) of the customers pr store.
Now i need a top 10 items for thouse top 10 customers, pr top 10 stores
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.