SUM of multiple entries

[abukapsoun]

Hi,

Need your help please. I have the below table, and would like to know the formula I can use to calculate the SUM of distinct values. I want to have the calculation looks like the following: 20 + 15 + 17 

Day1	20
Day1	20
Day1	20
Day2	15
Day2	15
Day3	17
Day3	17
Day3	17

Thank you

[Mahesh0016 · Accepted solution]

SUM of distinct = Sumx(Distinct(Community[Events]), [Events])

hello @abukapsoun