Sum of Distinct Value

[AwasthiAyush]

Hello,

I am trying to sum the Term values i.e. 126 + 369 but when I use sum it adds all the values and gives 4940. How can I just add the two values in my screen.

 

 

[johnt75 · Accepted solution]

Try creating a measure like

Sum of distinct term values =
SUMX ( DISTINCT ( 'Table'[2022_Term_value] ), 'Table'[2022_Term_value] )