Category fetching using RANK

Hi Anonymous ,

According to your description, I create a sample.

Here's my solution. For example, your logic for sorting products is total sales.

1.Create a calculated column Rank.

Rank =
RANKX (
    ALL ( 'Table' ),
    SUMX (
        FILTER ( ALL ( 'Table' ), 'Table'[Category] = EARLIER ( 'Table'[Category] ) ),
        'Table'[Sales]
    ),
    ,
    DESC,
    DENSE
)

Get the rank column.

2.Put date and sales in a column chart, for the best selling, put Rank into the visual filter and select the value is 1.

In the same way, for the 2nd most selling, select the visual filter to 2. For the 3rd most selling, select the visual filter to 3. Get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.