Sum a Column only where the values of another column are distinct

[Marc_S]

Hello,

Im trying to sum _TotalCompletedPerWeek but only once per _WeekCompleted distinct value
(ie only the values  2,5,5,3,6 in _TotalCompletedPerWeek relating to 1,2,3,4,5 in _WeekCompleted)

[Shishir22 · Accepted solution]

Hello @Marc_S ,

Please try below measure if it works-

Measure = SUMX(SUMMARIZE(Data,Data[_WeekCompleted],Data[_TotalCompletedWeek]),Data[_TotalCompletedWeek])

It will be great if you can provide sample data and expected result.

If this solves the requirement, please mark it as solution.

Thanks!

[Marc_S]

That worked! thank you