Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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])
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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])
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
That's worked exactly how i wanted, thank you for your help!