DAX trouble

[Kieran-q_20]

Hi Everyone, 

So i'm running into trouble with my DAX. Basically i want to create a measure that filters a table to give me the data i want. However my problems occur when i try to filter the same column multiple times. For example, Below i have attatched my DAX, It does not allow me to filter SLOC multiple times. I know my DAX must be wrong but i cannot figure it out.

TH Total = Sumx(FILTER('SVT Rolling', 'SVT Rolling'[plant] ="TH" && 'SVT Rolling'[sloc] = "DRE2" && 'SVT Rolling'[sloc] ="LOG1" && 'SVT Rolling'[sloc] ="RF02" && 'SVT Rolling'[sloc] ="RMA1" && 'SVT Rolling'[sloc] ="SH02"), 'SVT Rolling'[TC])

Any help is really appreciated, thank you 

[parry2k · Accepted solution]

@Kieran-q_20 maybe you need this:

TH Total = Sumx(FILTER('SVT Rolling', 'SVT Rolling'[plant] ="TH" && 
'SVT Rolling'[sloc] IN { "DRE2", "LOG1", "RF02", "RMA1", "SH02" } ), 'SVT Rolling'[TC])

[Kieran-q_20]

That's worked exactly how i wanted, thank you for your help!