DAX: ADDCOLUMNS & SUMMARIZE with Filter - Need Help

[Power_MN]

Hello everybody, Unfortunately, I can't get any further with one issue. I would like to add a filter to the following DAX command that filters for a specific country. ADDCOLUMNS( SUMMARIZE(Table1, Table1[supplier], Table1[product]), "Average Price", [Average Price] ) --> Here I would like to filter for the country "America" Does anyone know a solution for my issue? Thank you so much! Michael

[jameszhang0805]

@Power_MN YOU are welcome. please click accept solution. thanks. 

[jameszhang0805 · Accepted solution]

Please try :

AMAveragePrice =
ADDCOLUMNS (
    CALCULATETABLE (
        SUMMARIZE ( Table1, Table1[supplier], Table1[product] ),
        Table1[supplier] = "America"
    ),
    "Average Price", [Average Price]
)

[Power_MN]

@jameszhang0805 That works! Thank you very much!