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" )
Here is the table and I am looking for a table matrix for each individual day.
% percentage =
DIVIDE([Passcount], ([Passcount] + [FailureCount]))
| Test Name | % pecentage |
| iqa | 97.7% |
| coverageweb-healthcheck | 100% |
| XMods And More | 99.53% |
| TimeStamp | TestName | message | Success | Count |
| Friday, April 29, 2022 | coverageweb-healthcheck | Passed | TRUE | 85 |
| Friday, April 29, 2022 | XMods And More | Passed | TRUE | 212 |
| Friday, April 29, 2022 | XMods And More | HTTP status: 500; response code: 2; response message: There has been a system error. | FALSE | 1 |
| Friday, April 29, 2022 | iqa | Passed | TRUE | 85 |
| Friday, April 29, 2022 | iqa | HTTP Error | FALSE | 2 |
| Thursday, April 28, 2022 | XMods And More | HTTP status: 500; response code: 2; response message: There has been a system error. | FALSE | 1 |
| Thursday, April 28, 2022 | coverageweb-healthcheck | Passed | TRUE | 288 |
| Thursday, April 28, 2022 | iqa | Passed | TRUE | 288 |
| Thursday, April 28, 2022 | XMods And More | Passed | TRUE | 719 |
AlexisOlson
Super User
Super UserYeah, those are the numbers I get too. I'm not sure what the error is.
- AlexisOlson
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.
yes, it worked! Thanks for your time.