DAX Calculate SUM of Conditional multiple columns

[Anonymous]

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", [Success] = "TRUE" then get SUM of Count

elseIf [TestName] = "IQA", [Success] = "TRUE" then get SUM of count

etc..

[AlexisOlson]

How about this?

PassCount =
CALCULATE (
    SUM ( Table1[Count] ),
    ALLEXCEPT ( Table1, Table1[TestName], Table1[Timestamp] ),
    Table1[Success] = "TRUE"
)

The logic is pretty much the same as this:

PassCount =
SUMX (
    FILTER (
        ALL ( Table1 ),
        Table1[Success] = "TRUE"
            && Table1[TestName]  = EARLIER ( Table1[TestName]  )
            && Table1[Timestamp] = EARLIER ( Table1[Timestamp] )
    ),
    Table1[Count]
)

[Anonymous]

Ok, I tried! but somehow the calculation is messing with me. I need to get the percentage and realized I have one category for each day so skipped the Timestamp.

FailureCount = CALCULATE ( SUM ( AvailabilityResults[Count] ),ALLEXCEPT ( AvailabilityResults, AvailabilityResults[TestName]), AvailabilityResults[Success] ="FALSE")

PassCount= CALCULATE ( SUM ( AvailabilityResults[Count] ),ALLEXCEPT ( AvailabilityResults, AvailabilityResults[TestName]), AvailabilityResults[Success] ="TRUE")

Percentage= 

DIVIDE([Passcount], ([Passcount] + [FailureCount]))

Ex: TestName = IQA, Coverage,  I have only PassCount = 85 for today and I am expecting 100% but it is 99.97%/99.86%

[AlexisOlson]

I certainly wouldn't expect it to work if you remove [TimeStamp] from the measure.

[Anonymous]

okay, I added Timestamp, and it' same. I see that it's counting all FALSE values regardless of the TestName category. 

I need to count for each TestName and Success, 

[AlexisOlson]

Can you share some example data in a format that can be copied and pasted from? Please include the result you expect to match as well.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[Anonymous]

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]

Yeah, those are the numbers I get too. I'm not sure what the error is.

[Anonymous]

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 · Accepted solution]

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" )

[Anonymous]

yes, it worked! Thanks for your time.