Reply
Frequent Visitor
Posts: 4
Registered: ‎01-09-2019
Accepted Solution

Top Salesperson displayed in a card

[ Edited ]

I need to display in a card, the name of the salesperson with the highest number of sales. I feel like this must be simpler than the solutions i've tried (unsuccessfully).


I want to display in a card the name of the sales person who has the highest value in another column of the same table, 'OrderQty'.

I want just the name, not the associated value. Any advice would be greatly appreciated. I feel like this is a simple generic problem, that I've been googling and trying to figure out for too long, but if needed i can provide more detail/data.


 

 


Accepted Solutions
Highlighted
Super User
Posts: 2,235
Registered: ‎09-19-2016

Re: Top Salesperson displayed in a card

[ Edited ]

Hi @BrianSch

 

Try the following measure: 

 

 

Top Seller =
VAR temp_table =
    SUMMARIZE (
        ALL ( Sales[Salesperson] );
        Sales[Salesperson];
        "SalesTotalValue"; SUM ( Sales[SalesTotal] )
    )
RETURN
    CALCULATE (
        MAX ( Sales[Salesperson] );
        FILTER (
            ADDCOLUMNS ( temp_table; "Rank"; RANKX ( temp_table; [SalesTotalValue] ) );
            [Rank] = 1
        )
    )

Check the PBIX file attach with the result, this can need some changes depeding on your table setup.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Attachment

All Replies
Highlighted
Super User
Posts: 2,235
Registered: ‎09-19-2016

Re: Top Salesperson displayed in a card

[ Edited ]

Hi @BrianSch

 

Try the following measure: 

 

 

Top Seller =
VAR temp_table =
    SUMMARIZE (
        ALL ( Sales[Salesperson] );
        Sales[Salesperson];
        "SalesTotalValue"; SUM ( Sales[SalesTotal] )
    )
RETURN
    CALCULATE (
        MAX ( Sales[Salesperson] );
        FILTER (
            ADDCOLUMNS ( temp_table; "Rank"; RANKX ( temp_table; [SalesTotalValue] ) );
            [Rank] = 1
        )
    )

Check the PBIX file attach with the result, this can need some changes depeding on your table setup.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Attachment
Frequent Visitor
Posts: 4
Registered: ‎01-09-2019

Re: Top Salesperson displayed in a card

Thank You! You've helped me understand how to set the arguments up for the functions used as well!

note for other users: You need to change the semicolons to commas from the code snippet and it works perfectly! Or download his attached PBIX.