top n sales client by seller

[Sofinobi]

hello all ,

please,

i have a sales table with columns : clients - sellers - amount
i have a measure to calcule the total sales [Sales]
i need to calculate the percentage of the [Sales] of the top 2 client for each seller comparing for the total sales.

thank you for your help
TOP N.pbix 

[ppm1 · Accepted solution]

Here are two measures that should do it.

Top2 Sales =
VAR tSummary =
    ADDCOLUMNS ( VALUES ( Sales_Tab[Client] ), "cSales", [Sales] )
RETURN
    SUMX ( TOPN ( 2, tSummary, [cSales], DESC ), [cSales] )

Not Top2 Sales =
VAR tSummary =
    ADDCOLUMNS ( VALUES ( Sales_Tab[Client] ), "cSales", [Sales] )
VAR vCount =
    COUNTROWS ( tSummary )
RETURN
    IF (
        vCount >= 4,
        SUMX ( TOPN ( vCount - 2, tSummary, [cSales], ASC ), [cSales] )
    )

Pat

[Sofinobi]

thank you so much @ppm1 , it's perfect 
thanks  a lot.