DAX table using SUMMARIZE and multiple filters on columns

[samc_26]

Hi all, I'm trying to create a table that groups by two columns and does a count on a third for the values but I also need to filter against some other columns. So far I've managed to put this together which shows me the columns how I want them to appear but only filters the [US] column by the single value "ACKL".

I have multiple values which I need the [US] column to filter against but I can't figure out how to write this out... Is it possible to do multiple conditions using these expressions or do I need to change it completely? I would be very grateful if anyone can help me with this, I've spent many hours trying to work it out myself unsuccessfully! Thank you for reading, below is the code 😊

Table new =

    SUMMARIZE(

        FILTER('ERP/ECC','ERP/ECC'[US] = "ACKL"),

        'ERP/ECC'[Area], 'ERP/ECC'[Released Week Commencing],

"Total orders", DISTINCTCOUNT('ERP/ECC'[Order]))

[Anonymous]

Hi @samc_26 ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.

[Anonymous]

Hi @samc_26 ,
I wanted to check and see if you had a chance to review our previous message. Please let us know if everything is sorted or if you need any further assistance.
Thank you.

[Anonymous]

Hi @samc_26 ,
Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

[bhanu_gautam · Accepted solution]

@samc_26 , Try using

DAX
Table new =
SUMMARIZE(
FILTER(
'ERP/ECC',
'ERP/ECC'[US] IN {"ACKL", "VALUE1", "VALUE2"} // Add your values here
),
'ERP/ECC'[Area],
'ERP/ECC'[Released Week Commencing],
"Total orders", DISTINCTCOUNT('ERP/ECC'[Order])
)