Trying to Divide Count of Filtered Value by Another Count of Filtered Value

[Shane_lees]

So I have a table called Perf_Data and a column within which is Activity. Within activity is two distinct values - Sent and 1st IV. All the values in this column are text format.

I need to have a measure which divides the count of one, by the count of the other.

The bit I'm struggling with is the filtering by each individual value. My understanding is you would use {"Sent"} but I keep getting Syntax errors.

Below is as far as I've gotten, but I cannot get it to work. Can anybody help as I'm pretty much tearing my eyeballs out what I think should be simple but is just not coming together.

DIVIDE(COUNTA('Perf_Data'[Activity]{"1st IV"})), COUNTA('Perf_Data'[Activity]{"Sent"}))

[johnt75 · Accepted solution]

My Measure =
VAR FirstIV =
    CALCULATE ( COUNTROWS ( 'Perf data' ), 'Perf data'[Activity] = "1st IV" )
VAR Sent =
    CALCULATE ( COUNTROWS ( 'Perf data' ), 'Perf data'[Activity] = "Sent" )
RETURN
    DIVIDE ( FirstIV, Sent )