Forum Discussion

Kieran-q_20's avatar
Kieran-q_20
Helper I
2 years ago
Solved

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 sam...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    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])
parry2k's avatar
parry2k
Super User
2 years ago

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's avatar
Kieran-q_20
Helper I
2 years ago

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