Having trouble calculating % Success Rate

[shelbsassy]

I am trying to get the % Success Rate and the attempts I have tried aren't giving me correct percentages. 

I have a calculated column that calcualtes the number of Interventions (flagged as an intervention if a letter was sent or a nurse was notified so Status_ID 5 or 😎

Intervention Count = IF(Sheet1[status_id]=5||Sheet1[status_id]=8,1,0)

(When I look in the data that is working correclty flagging only 5s and 8s with 1s.)

So I thought I should create a measure to sum the Intervention Counts like

Sum Interventions=sum(Sheet1[Intervention Count])

Then I have Success Count:

Success Count = IF(Sheet1[status_id]=1||Sheet1[status_id]=4,1,0)

and then Sum Success = SUM(Sheet1[Success Count])

ThenI try and do a Measure to get the percentage success rate like this:

Success Rate = DIVIDE(Sheet1[Sum Success]/Sheet1[Sum Interventions],0)

I get a blank value.  Any thoughts on what the issue could be?  Thank you so much!

[shelbsassy]

EDIT

I meant when I tried Success Rate = DIVIDE(Sheet1[Sum Success]/Sheet1[Sum Interventions],0) I get nothing.  (I had them backwards)  Thanks!

[v-micsh-msft]

Hi shellbsassy,

What is your current situation?

Divide () function is the same as "/" symbol. If you use "/", then there is no need to use DIVIDE ( ) function.

DIVIDE function reference: DIVIDE Function (DAX)

Format should be: DIVIDE(<numerator>, <denominator> [,<alternateresult>])  

So the right way to use the DIVIDE function is:

DIVIDE(Sheet1[Sum Success],

            Sheet1[Sum Interventions],

           0),

as Sean suggested.

If any further help needed, please post back.

Regards

[shelbsassy]

The comment worked perfectly!  Thank you both for your help!

[Sean · Accepted solution]

@shelbsassy change the / to a comma! This shoud fix it!