topic Re: top n sales client by seller in DAX Commands and Tips

top n sales client by seller

Sofinobi — Sun, 19 Feb 2023 12:35:14 GMT

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

Re: top n sales client by seller

ppm1 — Sun, 19 Feb 2023 14:36:08 GMT

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

Re: top n sales client by seller

Sofinobi — Mon, 20 Feb 2023 10:17:33 GMT

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