Forum Discussion

shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
9 years ago
Solved

Having trouble calculating % Success Rate

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 inter...
Need Help
  • Sean's avatar
    Sean
    9 years ago

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

shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
9 years ago

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's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
    shelbsassy
    Icon for Resolver I rankResolver I
    9 years ago

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