Display Top 1 customer on Card Visual

[Anonymous]

Hi all!

So I have a table 'Product' with columns:  [Country], [Customer Name], [Product Category], [Prodcut Name], [Prodcut UPC]

And based on this, I created a calculated column [Unit Count] = DISTINCTCOUNT(Product[Prodcut UPC])

Now I need to create a card visual to display the top 1 customer with all the cross-filtering on the page, aka the customer bought the most units disregard the price and product type, and here's what I tried: 

[Top Customer] = 

CALCULATE(SELECTEDVALUE(asset[Customer Name]),

TOPN( 1, ALL(Product), [UnitCount],DESC ))

However, it's being calculated across each row and can't give me the top 1 customer name. I also tried FIRSTNONBLANK and couldn't get it to work. What am I missing here? please help! Thank you so much!! 

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

If you want the count can be filtered by  all the cross-filtering on the page. We can also use the following measure to meet your requirement:

TopCustomer =
MAXX (
    TOPN (
        1,
        SUMMARIZE (
            Product,
            Product[Customer Name],
            "Count", DISTINCTCOUNT ( Product[Prodcut UPC] )
        ),
        [Count], DESC
    ),
    [Customer Name]
)

Best regards,

[amitchandak]

Put Customer name on card. In visual filter drag filter Top 1 based on [UnitCount].

Refer , Brand dragged as measure and again dragged to filter and Top 1 has been used.