Forum Discussion
Sum of Distinct Value
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. ...
Try creating a measure like
Sum of distinct term values = SUMX ( DISTINCT ( 'Table'[2022_Term_value] ), 'Table'[2022_Term_value] )
johnt75
Super User
Super UserTry creating a measure like
Sum of distinct term values =
SUMX ( DISTINCT ( 'Table'[2022_Term_value] ), 'Table'[2022_Term_value] )