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

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.