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] )
1 Reply
johnt75Super User
Try creating a measure like
Sum of distinct term values = SUMX ( DISTINCT ( 'Table'[2022_Term_value] ), 'Table'[2022_Term_value] )