Counting quantities in 2 tables

[macemit]

I wonder if someone can help me. I have 2 tables: a failures table and a serial numbers table. Serial number key is joined on its foreign key in failures table. Both tables have a CreatedDate field. When I make a chart starting with the failures table I can get a count of failures, but when I drag serial numbers to values, and count them I get the same grand total number of serial numbers populating all the fields, rather than serial numbers per month:

	Failures	Serial Numbers
2017
January	45	12000
February	144	12000
March	233	12000
April	86	12000
May	65	12000
June	135	12000
July	99	12000
August	75	12000
September	54	12000
October	154	12000
November	21	12000
December	78	12000

Can someone tell me what I'm doing wrong?

[PattemManohar · Accepted solution]

Could you please confirm or make sure that there is a relationship between Date table and Serial Numbers table.

[v-jiascu-msft]

Hi @macemit,

Do you have a date table? But the date field isn't from the date table. Please share a sample file?

Best Regards,

Dale

[Anonymous]

Can you post the ssample ource data ( in copy , pasteabale format) and how they ae related.