please Help Dax for smart narrative

Hi， firstch ；

You could change it such as:

rank = 
CONCATENATEX (
    FILTER (
        ALLSELECTED ( 'financials'[Country] ),
        RANKX (
            ALL ( financials ),
            CALCULATE ( [total], ALLEXCEPT ( financials, 'financials'[Country] ) ),
            ,
            DESC,
            DENSE
        ) <= 3
    ),
    'financials'[Country],
    ",",
    [total], DESC
)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, firstch ,

You could try it.

rank = 
CONCATENATEX ( FILTER( ALLSELECTED( 'Table'),[product]=MAX([product])&&
        RANKX (
            FILTER( ALLSELECTED ( 'Table'),[product]=MAX([product])),
            CALCULATE ([Total]),
            ,
            DESC,
            DENSE
    )
   
 <= 3
    ),
   'Table'[country],
    ",",
   [Total], DESC
)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.