Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago
Solved

Divide

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 e...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    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

Bifinity_75's avatar
Bifinity_75
Icon for Solution Sage rankSolution Sage
3 years ago

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's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago

Thank you for your help