Calculate Win ratio for sales person

[deepsprime]

Hi

I am building reports on top of Dynamics CRM. I need to create a bar graph to who win ratio per salesperson.

The number of deals closes as won/ number of deals created.

I have created a calculated column to get won deals. This is showing on graph. How do I divide that by total applications of that salesperson and then show that number?

Thanks.

[v-shex-msft]

HI @deepsprime,

Please share some dummy data with a similar data structure to help us clarify your data structure and test to coding formula on it.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

@deepsprime ,

Try like

divide(calculate(count(Table[ID]),Table[Status]="Won"),calculate(count(Table[ID])))