How to Sum Values without adding up the duplicate values in Y-axis

[Julius Benn Sabeniano]

Hi,

I understand that we can use over and interset functions whenever we need to sum or count values in a specific group.

But, what if I would like to get the sum of the values in a Y-axis not adding up the same values or duplicate values. (sum of distinct values)

I would like to get the sum of the slider count by Date not adding up the duplicate values from the column value.

[Julius Benn Sabeniano]

I used this functions to rank the duplications to my data and if statement to null the duplicate values.Sum(If(rank(baserowid(),"asc",[unique column])=1,[values],null))