Forum Discussion

Switto's avatar
Switto
Helper IV
4 years ago
Solved

Accuracy % for monthwise

Hi Everyone, I am trying to get the month-wise accuracy % for my team. I have tried the below simple DAX code: 1-(DIVIDE([mCount_Error],[mCount_shoppingCart],"NA")) It is showing the correct data...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    Switto you can wrap it around the if conditions:

     

    IF ( NOT ISBLANK ( [mCount_Error] ) && NOT ISBLANK ( [mCount_shoppingCart] ),
1-(DIVIDE([mCount_Error],[mCount_shoppingCart],"NA"))
)

     

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

     

    Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Super User
4 years ago

Switto you can wrap it around the if conditions:

 

IF ( NOT ISBLANK ( [mCount_Error] ) && NOT ISBLANK ( [mCount_shoppingCart] ),
1-(DIVIDE([mCount_Error],[mCount_shoppingCart],"NA"))
)

 

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.