best sellers column and filter

Laocsulak — Fri, 03 Feb 2023 18:26:04 GMT

Hello,

I have created a simple matrix with the customers and their purchases, like in the next dummy example:

I would like to know if there's a way to add a column and/or a filter that shows who are the 3 top sellers, who are "1", "2" and "3" in this example.

Files:

Thanks in advance!

Re: best sellers column and filter

FreemanZ — Fri, 03 Feb 2023 23:26:29 GMT

try to add a measure to the matrix visual:

Ranking =

RANKX(

ALLSLEECTED(TableName[buyer]),

CALCULATE(SUM(TableName[amount]))

)