Divide

[M_SBS_6]

Hi, 

I need a new calculation to divide one value by another using a filter.

count surv_id / count surv_id where surv_log = "yes"

Surv_id =4

count surv_id where surv_log "yes" =3

So I expect 75%

Any idea how to write this out please? 

[Bifinity_75 · Accepted solution]

Hi @M_SBS_6 , try this measure:

Count_yes = var p_=CALCULATE(count('Table'[surv_id]),'Table'[surv_id]="yes")
return
DIVIDE(p_,COUNT('Table'[surv_id]),"-")

Best regards

[M_SBS_6]

Thank you for your help