Combine two values based on text

Hi Schneider879,

It seems that you want to calculate the Total Unique Clicks based on the same group.

You could create the calculated column or the measure to achieve that.

Here is my simple sample.

Assuming that this is the original table.

Then you could split columns in Query Editor and you will get the table like below.

Then you could create the calculate column or the measure.

Column =
CALCULATE (
    SUM ( Table1[Ticks] ),
    FILTER (
        'Table1',
        'Table1'[Company - Copy.1] = EARLIER ( 'Table1'[Company - Copy.1] )
    )
)

Measure = CALCULATE(SUM(Table1[Ticks]),ALLEXCEPT(Table1,'Table1'[Company - Copy.1]))

Here is the ouput.

More details, you could refer to my attachment.

Best  Regards,

Cherry