Top 1 customers by product with sales

[HarishRathore]

Hi,

I have a data model in power pivot where I wanted top  customer per product using this measure : 

Top Customer Name = Maxx(TopN (1, Summarize ( Customers, Customers[Customers Name], "Vol", [Total Volume]), [Vol], DESC ), Customers[Customers Name])

I am getting desired result but only thing is when i am putting brand in row field and the said measure in value field then i am getting result but the moment put "Total Volume" in value field then i am getting the complete volume of that particular brand against that top outlet but I want that what is volume of that brand against that top outlet. Can you please help me in this regards????

Regards

[v-diye-msft]

Hi @HarishRathore 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[PaulDBrown]

@HarishRathore 

You can use the RANKX function for this:

Here is my sample model

The RANKX measure to rank customers by product:

RankX Customer = RANKX(ALL(Cutsomer[Customer]); [Sum Sales]; ;DESC;Dense)

and finally visual to only show top 1 with corresponding sales:

Does that work?

[amitchandak]

Refer :

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[HarishRathore]

Thanks for your reply but its not proving solution where I need Number 1 customers of each product and sales of that product of that Number 1 customer.

[amitchandak · Accepted solution]

In Rank use sub category Rank and filter for 1.

Refer filtering :https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...