topic Re: Top selling country per supplier overall in DAX Commands and Tips

Top selling country per supplier overall

WSeirafi — Fri, 09 Feb 2024 14:32:53 GMT

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

Re: Top selling country per supplier overall

bhanu_gautam — Fri, 09 Feb 2024 17:25:29 GMT

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

Re: Top selling country per supplier overall

WSeirafi — Mon, 12 Feb 2024 11:24:53 GMT

Hello,

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