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 however while putting it in graph/table, it is showing 100% for the future months as well(which we did do any audit).

MonthNamem%Accuracy
Jan'2275%
Feb'22100%
Mar'22100%
Apr'22100%
May'22100%
Jun'22100%
Jul'22100%
Aug'22100%
Sep'22100%
Oct'22100%
Nov'22100%
Dec'22100%

 

If I remove the 1 from the formula"=DIVIDE([mCount_Error],[mCount_shoppingCart],"NA")", it is showing me the Error % for the particular month only.

PS: I am using the calendar table.

Please let me know if we have any workarounds.

Thanks

S

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.

1 Reply

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