Forum Discussion
DAX Calculate SUM of Conditional multiple columns
I am looking for DAX for the below condition where get the SUM of Count for each individual TestName and Success column for that individual date. PassCount = If [TestName] = "XMods And More", ...
I was thinking in terms of a calculated column.
Since you're doing this as a measure, I think it can be simpler:
CALCULATE ( SUM ( Table1[Count] ), Table1[Success] = "TRUE" )
AlexisOlson
Super User
Super UserI was thinking in terms of a calculated column.
Since you're doing this as a measure, I think it can be simpler:
CALCULATE ( SUM ( Table1[Count] ), Table1[Success] = "TRUE" )yes, it worked! Thanks for your time.