Dividing two results from filtered tables

[kosser32]

I have 2 tables . One is a CRM table that has a list of buiness driving call by sales person

CRM output filtered by BD Calls as a Count

Rep           Staus Reson set to BD Calls

T101                 32

T102                 30

T103                 29 

T104                 30

The Days worked table show number of days worked

Rep          Days Worked

T101              10

T102               12

T103               9

T104              9

I need to be able to show the conversion rate of each rep ie

The count of Buiness Driving calls divided by no of days works

[MFelix]

Hi @kosser32,

I'm assuming you tables are related by REP so just add this measure:

Conversion Rate = DIVIDE(SUM(CRM[Staus Reson set to BD Calls]);SUM('Days worked'[Days Worked]))

Should give you the expecte result.

Regards,

MFelix