Avoid duplicates doing the calculations

Hi dofrancis3 ,
Sorry I just saw your screen copy.

First you should unpivot all your columns except the country, year and quarter.

So you'll get all values in one column and one column which states if it is P1 or P2...

This column will be our filter in the visual (rows or column).

Then you remove the duplicates, (with dedicated button after selecting all your columns)

and finally you just have to sum up your values in a visual, maybe without any DAX at all.

Even though I would recommend a simple DAX Like : SUM( [Attribute] ).

Attribute being the name of your column with your values.

Then choose if you want the country in rows or columns,

and do the same with the column with values P1, P2.

If you provide sample data I can make you a quick pbix to show you.