Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Win Rate (best practice)

Hello   -   I am putting together an analysis of our CRM data.   

 

I've seen a number of examples of Win Rate % on the internet.   Does anyone that has done this type of analysis before have a recommendation as to the best pratice and a typical DAX formula?    

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may create measure like DAX below.

     

    Win Rate =
DIVIDE (
    CALCULATE (
        COUNT ( Table[Column] ),
        FILTER ( ALLSELECTED ( Table ), [Status] = "Win" )
    ),
    CALCULATE ( COUNT ( Table[Column] ), ALL ( Table ) )
)

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • marceloVVR's avatar
    marceloVVR
    Helper I
    6 years ago

    Are you using measures to return the percentage of results?

    Try to create using the DIVIDE function
    Doc link: https: //docs.microsoft.com/en-us/dax/divide-function-dax

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You may create measure like DAX below.

     

    Win Rate =
DIVIDE (
    CALCULATE (
        COUNT ( Table[Column] ),
        FILTER ( ALLSELECTED ( Table ), [Status] = "Win" )
    ),
    CALCULATE ( COUNT ( Table[Column] ), ALL ( Table ) )
)

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.