Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

unique value in measure column

Hi All, I am trying to get sum of only distinct measure values for a particular Name if the value is repeated.   Name Code Type Price 10G 72 S 10 11C 86 A 12 3D 18 S 10 ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Sum of unique values =
SUMX ( SUMMARIZE ( 'Table', 'Table'[Name], 'Table'[Price] ), 'Table'[Price] )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Sum of unique values =
SUMX ( SUMMARIZE ( 'Table', 'Table'[Name], 'Table'[Price] ), 'Table'[Price] )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi John,

Thanks for your inputs tried the suggestion but still the same.

Also tried below measure nothing seems to work

  SUMX(VALUES('Table'[Price]),'Table'[Price])
please suggest if we have any other option
Thank you
  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    Are you sure you used the right measure in the second table visual, both columns have the same name ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Apologies John you are right some how while testing I might have added the same measure 

      Thank you again the measure works