Error in totaling of Table

[Anonymous]

Hi,
I am beginner, I am using Table and Sample Data is given below;
Data for Plan:
Field/Well Name	Concession	Month	Plan MBOPD
ABC	XYZ-1	Jan-20	1.11
ABC	XYZ-1	Feb-20	1.51
ABC	XYZ-1	Mar-20	2.20
ABC	XYZ-1	Apr-20	1.46
ABC	XYZ-1	May-20	1.30
ABC	XYZ-1	Jun-20	1.16
ABC	XYZ-1	Jul-20	1.05
ABC	XYZ-1	Aug-20	0.95
ABC	XYZ-1	Sep-20	0.86
ABC	XYZ-1	Oct-20	0.79
ABC	XYZ-1	Nov-20	0.72
ABC	XYZ-1	Dec-20	0.66
Total			13.76
Data for Actual:
Field/Well Name	Concession	Month	Actual MBOPD
ABC	XYZ-1	Jan-20	1.11
ABC	XYZ-1	Feb-20	1.51
ABC	XYZ-1	Mar-20	2.20
ABC	XYZ-1	Apr-20	2.18
ABC	XYZ-1	May-20	1.74
ABC	XYZ-1	Jun-20	1.47
ABC	XYZ-1	Jul-20	1.41
ABC	XYZ-1	Aug-20	1.21
ABC	XYZ-1	Sep-20	1.03
ABC	XYZ-1	Oct-20	0.90
ABC	XYZ-1	Nov-20	0.78
ABC	XYZ-1	Dec-20	0.68
Total			16.22
Totals below the Data are just for your ease, while uploading data in Power BI have excluded Total Row.
Relationship column is "Field/Well Name" in above DATA.
When I filter table on May-20 it gives;
Field/Well Name	Concession	Month	Plan MBOPD	Actual MBOPD
ABC	XYZ-1	May	1.3	16.22
1.3 is correct, but in last column instead of 16.22 it should be 1.74
I want result based on filter.

[Pragati11]

Hi @Anonymous ,

What is the direction of your relationship? If it is single, try making it bi-directional. It should work.

[Anonymous]

HI @Pragati11 , It was both ways.

[Anonymous · Accepted solution]

Hi @Anonymous 

I know it is frustating to see the data not getting displayed as per your requirement.

So, What is happening here is that first table one record joins with all the records of 2nd table as the join is on Field/Well Name resulting in the total sum of 16.22.

I would create a key column in both the tables as

Key_col = CONCATENATE(CONCATENATE(Field/Well Name, Concession), Month)

and join on this key column.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Regards,
Pranit

[Anonymous]

Thank you very much pranit828, this has worked.