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" )
oh my bad! I am using a table instead of a matrix and don't want to show Timestamp, so I did a relation with the date table separately and applied ISToday = Yes on the filter, and this is what I get.
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.