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.

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