Calculating percentages with monthly and daily data

[dw700d]

Hello, 

I have two tables with approx 1 million rows. Each table includes data from Jan 2018 until Present.  The "Count of Fees Waived" column is based on daily inputs.This data includes site and Agent. The "Calls Handled data" is based on monthly inputs, it includes site but does not include agent.  I am trying to calculate Monthly Count of Fee Waiver rates as a percentage of Monthly Calls Handled.  I tried to create a new measure to calculate "Monthly Fee Waiver Rates" and when I view this new measure by month the calculation is way off, it is extremely low.  I believe it has something to do with my "Count of Fee Waivers" data being daily while my "calls handled" data is monthly.  I also tried to establish a relationship between the two tables but this did not work.  My end goal is to include the Monthly Count of Fee Waiver rates in a chart that allows me to drill down to site level and agent level. Can anyone help me?

Months	Site	Calls Handled
Jan	stanton	9113
Jan	overtown	9698
Jan	kingston	3515
Jan	linstead	10810
Jan	mabelton	13045

Date	Site	Agent id	Count of Fee Waivers
1/1/2018	stanton	abcd	2
1/2/2018	overtown	adsdsd	6
1/3/2018	mableton	dsfsf	1
1/4/2018	linstead	sds	9
1/5/2018	burchell	asasa	1

[Greg_Deckler · Accepted solution]

You will need a relationship between the two based on Site. To do this, create a bridge table like:

Table = DISTINCT('Table'[Sites])

Alternatively, you could create a column in each table like this:

Column = CONCATENATE([Months],[Site])

Column = CONCATENATE(FORMAT([Date],"mmm"),[Site])

And use those as your relationship.

[dw700d]

Greg Deckler..Thank you very much that did the trick