Forum Discussion

RickardBengzon's avatar
RickardBengzon
Frequent Visitor
4 years ago
Solved

My card doesn't sum duplicates

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. 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi RickardBengzon ,

     

    Check the measure.

    Measure =
    var _sum = SUM('Table (2)'[value])
    return
    SUMX('Table (2)',_sum)
     
    Best Regards,
    Jay

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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])

  • filipeoliveira's avatar
    filipeoliveira
    Icon for Helper I rankHelper I
    4 years ago

    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])))
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi RickardBengzon ,

     

    Check the measure.

    Measure =
    var _sum = SUM('Table (2)'[value])
    return
    SUMX('Table (2)',_sum)
     
    Best Regards,
    Jay