Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display Top 1 customer on Card Visual

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!! 

 

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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,

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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.

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,