Count with DAX when specific value

Question

Greetings,&nbsp;I need help on how to count data when we have an specific value. Sorry in advance if this has been answered somewhere else, I tried several cases found here but none of them worked for this case.&nbsp;Our goal: Obtain the Nº of TestCode that have zero Pass_Fail_Error “F” value, 1 or more than 1.&nbsp;Given a table like this one here.Testcode nº of F per Testcode&nbsp;We should get an array like this.Measure: [nº of TestCode = 0, nº of TestCode = 1, nº of TestCode &gt; 1]Example:Measure [1, 1, 2]______________________________Or 3 diferent measuresMeasure 1: Nº of TestCode that have zero Pass_Fail_Error “F” value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 1Measure 2: Nº of TestCode that have one Pass_Fail_Error “F” value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1Measure 3: Nº of TestCode that have more than 1 Pass_Fail_Error “F” value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;Does anyone know how to solve this?

anonymous · Accepted Answer

HI&nbsp;Anonymous&nbsp;,
You can create a variable with summarize function to aggregate records that has Code 'F' and group based on ‘Test Code’ and ‘FPcode’ categoried, and add custom fields to get correspond record count.
formula =
VAR summary =
    SUMMARIZE (
        FILTER ( ALLSELECTED ( Table ), [Fail_Pass_Code] = "F" ),
        [TestCode],
        [Fail_Pass_Code],
        "_Count", COUNTA ( Table[Fail_Pass_Code] )
    )
RETURN
    SUMX ( summary, [_Count] )
Regards,
Xiaoxin Sheng

Forum Discussion

Count with DAX when specific value

1 Reply

Related content

Count specific values

Count occurrences of specific values in a column

Counting nulls

How to count rows with specific value in Power Query

Counting based on specific value