Call Productivity in percent

[morab]

Dear All,

I have a list of two tables. 

1st: Target Customer by Route

2nd: Transactional Data

Total Target Customer by Route
Route	Total Customer#
A	50
B	100
C	40
D	80

Transactional Data
Date	Route	CustomerCalled#
01/01/2021	A	30
02/01/2021	B	80
03/01/2021	C	39
04/01/2021	D	80
05/01/2021	A	45
06/01/2021	B	85
07/01/2021	C	40
08/01/2021	D	70

Based on the above information, I want to calculate productive call in percentage by route. 

Expected Result:

Productive Call %
Route	CustomerCalled	TargetCustomer	Productive Call %
A	75	100	75%
B	165	200	83%
C	79	80	99%
D	150	160	94%

Could you please help!

Thanks in advance!

@amitchandak @morab @Jihwan_Kim 

[Jihwan_Kim · Accepted solution]

Hi,

I assume the target is a daily target.

Please check the sample pbix file's link down below.

All measures are in the sample pbix file.

Link to the sample pbix file 

[morab]

Thanks a TON 😊

[lbendlin]

see attached

[morab]

Thanks a ton!

One humble request, Can it be possible to generate using DAX measures/formula instead of creating a calculated column.

[lbendlin]

Which filters would influence the results?

[morab]

date & route filter