How to put the name of seller on a card in dashboard based on the max amount of sale?

[Vibration85]

How can I have only one name of the seller based on the max sales amount (or max number of sales)? I know I can have it in terms of Table Visualise but in a card only one name which is constant for every month for example. 

[mwegener]

Hi @Vibration85 ,

you can use TOPN and MAXX to create the desired measure.

[Vibration85]

I tried to use it in the filter pane as well but it doesn't work well I think, maybe I need to create a measure to show it and each month or week change based on it. 

[mwegener · Accepted solution]

Hello @Vibration85 ,

then take a look at my sample file.

[Vibration85]

Many Thanks, 😊 dear @mwegener , it works very well, I tried a lot before with MAX and Calculate but it was so ugly and not correct. I'm a newbie and trying to test different ways.

[parry2k]

@Vibration85 not fully clear what you are looking for. You need to provide some more details. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Vibration85]

Sorry for more clarification I will put my data in the below:

it was a big table I couldn't put all the columns but based on the max sales (Column Sales) I need to return one name which is in Customer or seller Column. I want to make a dashboard that displays on a card the name of this seller or Customer.

for example: if 529550 is Max Sales, the name of the seller is Chris XXX, I need to have the name of Chris XXX in the card and pin it in my dashboard.