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!

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

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

  • 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!