Show best sum amount in card

[LuisCP2012]

Hello,

Currently I have in my card value the best customer, my objective is to display best customer's total amount too on the card below.

The chart is currently showing the sum of all values categorized by each customer.

I've tried to do the same measure as I did with best customer, but it's showing only one of the receipts of the customer, and instead I would like to show me the sum of it, so I was trying to get the value of total amount filtering by the card value given, but it doesn't show

I know in SQL it would be like:

SELECT SUM(MON_TOT) 
FROM HIST_DOC
WHERE NOM_EMP = CARD_BESTCUSTOMER_VALUE (variable)
GROUP BY NOM_EMP;

[amitchandak · Accepted solution]

@LuisCP2012 ,

maxx(filter(values(Table[customer]),[Rank]=1),Table[Customer] & " " & Table[Amount])