Need Help for a matrix with multiples Rankx

Hi  MoonLightFlower ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Sum_Category =
 SUMX(
    FILTER(ALL('Table'),
    [country]=EARLIER('Table'[country])&&'Table'[Category]=EARLIER('Table'[Category])),
    [AmountSales])

Sum_SubCategory =
 SUMX(
    FILTER(ALL('Table'),   [country]=EARLIER('Table'[country])&&'Table'[Category]=EARLIER('Table'[Category])&&'Table'[SubCategory]=EARLIER('Table'[SubCategory])),
    [Qty])

2. Create measure.

This is a rule I created myself, and you can change the functions in it to the following form.

FILTER(
    _table1,
    [Rank_Category] <=10 && [Rank_SubCategory]<=5&&[Rank_Product]<=5)

Flag =
VAR _table1 =
    ADDCOLUMNS (
        ALL ( 'Table' ),
        "Rank_Category",
            RANKX (
                FILTER ( ALL ( 'Table' ), [country] = EARLIER ( 'Table'[country] ) ),
                [Sum_Category],
                ,
                DESC,
                DENSE
            ),
        "Rank_SubCategory",
            RANKX (
                FILTER (
                    ALL ( 'Table' ),
                    [country] = EARLIER ( 'Table'[country] )
                        && 'Table'[Category] = EARLIER ( 'Table'[Category] )
                ),
                [Sum_SubCategory],
                ,
                DESC,
                DENSE
            ),
        "Rank_Product",
            RANKX (
                FILTER (
                    ALL ( 'Table' ),
                    [country] = EARLIER ( 'Table'[country] )
                        && 'Table'[Category] = EARLIER ( 'Table'[Category] )
                        && 'Table'[SubCategory] = EARLIER ( 'Table'[SubCategory] )
                ),
                [Qty],
                ,
                DESC,
                DENSE
            )
    )
VAR _table2 =
    FILTER (
        _table1,
        [Rank_Category] <= 1
            && [Rank_SubCategory] <= 3
            && [Rank_Product] <= 5
    )
VAR _column =
    SELECTCOLUMNS ( _table2, "test", [Product] )
RETURN
    IF ( MAX ( 'Table'[Product] ) IN _column, 1, 0 )

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

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