My card doesn't sum duplicates

[RickardBengzon]

Hi!

I want to SUM the amout of time it takes to deliver to these places. The problem is where I have duplicates it only sum once.
So for example 682P25 is only sum:ed once 270 not 540 as I want it to be. As you can se on entry-time these are two different deliveries.

So I want the total amount in the right column in my card. The data is form two tables. One table contains Address and the expected delivery time. 

[v-jayw-msft · Accepted solution]

Hi @RickardBengzon ,

Check the measure.

Measure =

var _sum = SUM('Table (2)'[value])

return

SUMX('Table (2)',_sum)

Best Regards,

Jay

[filipeoliveira]

Hello,

I think you can try to use a measure with SUMX. It will be something like:

MeasureName = SUMX(DISTINCT(TableName[entry_time]),CALCULATE(SUM(TableName[time_seconds])))

[amitchandak]

@RickardBengzon , if duplicate was created because of relation it will not come in total 

Get duplicate in total - Correct table name

Sumx(Summarize(Table1, Table[Parcel ID], Table1[Entery Time], Table2[Delivery Address Short], "_1", Sum(Table2[Time]) ) , [_1])