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

Shane_lees — Wed, 28 Sep 2022 09:50:58 GMT

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

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

johnt75 — Wed, 28 Sep 2022 11:14:58 GMT

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 )

topic Trying to Divide Count of Filtered Value by Another Count of Filtered Value in DAX Commands and Tips

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

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