DAX measure for percent of combined string values in a column

[jeffatkins79]

Apologies if this is overly simple but I am new to DAX.  I am trying to calculate an escalation percentage as defined as (# of Escalated 2s + # of Escalated 3s) / (# of Assigned).  The data looks like:

Event Column

Assigned

Escalated 2

Assigned

Escalated 3

Assigned
Assigned

For the above data, the escalation percentage should be 50%. 

Thanks for your help

[Anonymous · Accepted solution]

HI @jeffatkins79 ,

You can try to use following measure to calculate percent of 'escalated' and 'assigned'.

Measure =
DIVIDE (
    COUNTROWS (
        FILTER (
            ALLSELECTED ( Table1 ),
            SEARCH ( "Escalated", [Event Column], 1, -1 ) > 0
        )
    ),
    COUNTROWS ( FILTER ( ALLSELECTED ( Table1 ), [Event Column] = "Assigned" ) )
)

Regards,

Xiaoxin Sheng