Forum Discussion
Resolver IAvoid duplicates doing the calculations
Super User
Please provide your expected output. If your data model consist mutiple duplicate column then suggesting you provide the data based on that..
Regards
sanalytics
Resolver IDear sanalytics, AilleryO , vivek31 , powerbidev123 ;
As per the table below I would like to calculate the Sum of each column by COUNTRY without duplication
Please see below example of output expected:
powerbidev123Solution Sage
dofrancis3 , 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
- dofrancis3
powerbidev123 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.