Forum Discussion
dofrancis3
Resolver I
Resolver IAvoid duplicates doing the calculations
Dear Colleagues, I would like to request your assistance please ! As you can see in the table below, I have duplicates. How can I proceed to make the calculation (sum) without considering the dupli...
powerbidev123
Solution Sage
Solution Sagedofrancis3 , try using this for Burkina Faso value column:P1
P1 =
SUMX(
SUMMARIZE(
FILTER( TableName, TableName[Country] = "Burkina Faso" ),
TableName[Year], TableName[Quarter], "UniqueP1", MAX(TableName[P1])
),
[UniqueP1]
)
If it works then use the same for other P2,z1,z2,m1,m2 columns as well
dofrancis3Resolver I
Resolver Ipowerbidev123 sorry it doen't work please just to let you know that Burkina foso is just an exemple of out kind of output i expect so i don't need to write Burkina faso in my DAX mesure because duplication can be for other countries.