Monthly grand total based on 4 different tables

[Seer_Bug]

I have 4 different tables with errors and error opportunity for different Site/location for each month.

I have created measure to get the consolidated error count from all 4 tables and another measure to get a consolidated error opportunity from all 4 tables.

These measures are in a table called Site_location which has only Site ID and Site Name. 

What i need is Site wise error count and error opportunity  for each month. however what I am getting is only the grand total of all error for site -  not sure how to get month wise breakdown.  how do i create relationship for month. Will share more details if required.  Kindly help.

Sample data :

Order Number	Month	Emp Name	Line	Site	Error	Error Opportunity
123	June	AB	V	UK	1	1
23	June	rt	W	USA	0	2
34	July	YU	V	USA	0	1
45	July	AB	V	UK	0	1
1	June	AB	V	UK	1	1
2	June	rt	W	USA	0	2
4	July	YU	V	USA	1	1
3	July	AB	V	UK	0	1

Expected result  for error % : 

Site	June	July
UK	100%	0%
USA	0%	50%

this is based on the calculation sum of errors for UK for June divided by sum of error opportunities for UK for June eg., for June Uk had 2 errors  divided by 2 error opportunities

later will have to present this in chart format

@Greg_Deckler 

[v-yiruan-msft]

Hi @Seer_Bug ,

You can create a measure as below:

error % = DIVIDE(SUM('Site info'[Error]),SUM('Site info'[Error Opportunity]),0)

Best Regards

Rena

[Seer_Bug]

Hi Rena, thanks for responding, i have 4 such tables where i need to consolidate similar data month wise.  

[v-yiruan-msft]

Hi @Seer_Bug ,

Could you please provide the structure and sample data of these 4 tables and existed relationships among these 4 tables?

Best Regards

Rena

[Greg_Deckler]

OK @Seer_Bug, using your updated information I did this:

Measure = SUM('Table (2)'[Error]) / SUM('Table (2)'[Error Opportunity])

[Seer_Bug]

Thanks for responding. with one table i have done the sum, However i have 4 such different table, wherein I need the output  as a consolidation  from all tables month wise

[Greg_Deckler]

@Seer_Bug Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.