Retrieve Top5 Countries Total from a table visual and have it displayed in a card visual?

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

In this case, one of ways is using WINDOW and RANK DAX functions in measures.

Please check the below picture and the attached pbix file.

WINDOW function (DAX) - DAX | Microsoft Learn

RANK function (DAX) - DAX | Microsoft Learn

Total sales: = 
SUM(sales[sales])

Top 5 countries within category: = 
VAR _topn =
    WINDOW (
        1,
        ABS,
        5,
        ABS,
        SUMMARIZE (
            ALL ( sales ),
            category[category],
            country[country]
        ),
        ORDERBY ( [Total sales:], DESC ),
        ,
        PARTITIONBY ( category[category] )
    )
RETURN
    CALCULATE (
        [Total sales:],
        KEEPFILTERS ( _topn )
    )

Ranking: = 
IF (
    [Top 5 countries within category:],
    RANK (
        SKIP,
        SUMMARIZE (
            ALL ( sales ),
            category[category],
            country[country]
        ),
        ORDERBY ( [Total sales:], DESC ),
        ,
        PARTITIONBY ( category[category] )
    )
)