Forum Discussion
DAX trouble
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
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])
2 Replies
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])That's worked exactly how i wanted, thank you for your help!
