Sum of two columns based on two filters?

[andrewkla]

No sure if the title descsribes what I want to do very well, basically I have this data:

Case ID	Date	Writer	Writer points	Checker	Checker Points
ID 245	March	James	100	Andrew	20
ID 548	March	Andrew	150	James	30
ID 874	April	Andrew	160	James	32
ID 965	April	Andrew	50	James	10
ID 587	April	James	80	Andrew	16

Writer points and checker points are the same points, which I need to visualise the sum of, per month, per person. This is the desired visualisation result:

Andrew	170	226
James	130	122
	March	April

Any help appreciated!

[Fowmy · Accepted solution]

@andrewkla 

I transformed your table in Power Query to a usable layout and just added the points using sum.

Please check the attached PBIX file and check the PQ steps

[andrewkla]

@Fowmy 

Thanks, this is indeed a good idea, however - something I should have probably mentioned - my Checker column is a calculated column (lookupvalue from another table where I have Case ID and Checker name). So I can't really pivot that, right?

Is there another way of doing it, or have I gone the wrong direction by creating this calculated column in the first place and should have resolved it by some kind of a measure that adds values from two original tables?

[Fowmy]

@andrewkla 

The right way is to organize your data as I did. If you need a measure, it is possible but not a recommended approach as you may have different names in the writer checker, and the filter by name and other columns are complex.