Sum - Calculated Column

[AllanBerces]

Hi good day,

Can anyone help me on my calculated column on how to arrived on my desired outcome.

Current Table

Desired Outcome adding calculated column

Thank you

[dvraan]

CALCULATE(SUMX(DISTINCT(data[count]), data[count]), ALLEXCEPT(data, data[date], data[location]))

But i suggest to use Remove duplicate in power query 

CALCULATE(SUM(data[count]), ALLEXCEPT(data, data[date], data[location]))

[Jihwan_Kim · Accepted solution]

Hi,

Please try something like below (the picture and the attached pbix file).

desired outcome CC = 
SUMX (
    FILTER (
        SUMMARIZECOLUMNS (
            data[date],
            data[location],
            data[trade],
            data[week_no],
            data[count]
        ),
        data[date] = EARLIER ( data[date] )
            && data[location] = EARLIER ( data[location] )
    ),
    data[count]
)

[dvraan]

CALCULATE(SUMX(DISTINCT(data[count]), data[count]), ALLEXCEPT(data, data[date], data[location]))

But I suggest Remove duplicate in power query 

CALCULATE(SUM(data[count]), ALLEXCEPT(data, data[date], data[location]))

[AllanBerces]

HI @Jihwan_Kim if you dont mine how can i chage the solution in to Measure.

Thank you

[AllanBerces]

Hi @Jihwan_Kim Thank you very much you save my day.