Top selling country per supplier overall

[WSeirafi]

Hello,

I have this measure which is working very well

Strategic Partner Top Country =

VAR vals =

    SUMMARIZE (

        Invoices,

        Geography[COUNTRY_NAME],

        Suppliers[Sup_Id],

        "Spend per country", [Spend YTD]

    )

VAR MaxSpend =

    MAXX ( vals, [Spend per country] )

VAR TopCountry =

    CALCULATE (

        MAXX (

            FILTER ( vals, [Spend per country] = MaxSpend ),

            Geography[COUNTRY_NAME]

        )

    )

RETURN

    TopCountry

This shows the top selling country, however if I filter on a region, it will show the top selling country of that region. I need it to ignore the slicer, however couldn't make it work with REMOVEFILTERS and ALL functions.

Any idea ?

Thanks for your help

[bhanu_gautam]

@WSeirafi , Try using below method

Strategic Partner Top Country =
VAR vals =
SUMMARIZE (
REMOVEFILTERS(ALL(Geography[COUNTRY_NAME])),
Geography[COUNTRY_NAME],
Suppliers[Sup_Id],
"Spend per country", [Spend YTD]
)
VAR MaxSpend =
MAXX ( vals, [Spend per country] )
VAR TopCountry =
CALCULATE (
MAXX (
FILTER ( vals, [Spend per country] = MaxSpend ),
Geography[COUNTRY_NAME]
)
)
RETURN
TopCountry

[WSeirafi]

Hello,

There is a syntax error, parameter is the not the correct type for REMOVEFILTERS(ALL(Geography[COUNTRY_NAME]))