Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

error is coming in division

Hi Experts, I am new to PowerBI. I am trying to create a Metrix but error message is coming which is highlighted in Red color. Kindly help me in the same. Below is the expression - =IFERROR(FORMAT(count(AD_V_Activity_Detail[Activity_Id])/ [Activity Target],"0.0%"),"0%"). Also I want to change column name but I am not able to do so. Kindly help me. Highlighed in blue color.

 

Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    Hi, it's a classic "Division By Zero" issue. tru to use DIVIDE() function like

    = FORMAT(DIVIDE(count(AD_V_Activity_Detail[Activity_Id]), [Activity Target], 0),"0.0%")

3 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

    Hi, it's a classic "Division By Zero" issue. tru to use DIVIDE() function like

    = FORMAT(DIVIDE(count(AD_V_Activity_Detail[Activity_Id]), [Activity Target], 0),"0.0%")
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank You so much .. Its working fine.

      🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Also can you please help to apply conditional formatting on "Activity Achv %" column.

      It is not happening through Conditional formatting because it is a calculated measure.

       

      I want -

      0% to 80% - Red

      81% to 99% - Yellow

      >100% as Green

       

      Kindly help