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

As long as the tables are related the same technique should work, you can summarize a table including values from a related table

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks johnt75  dont know but initially when I have writted same formula it throwed an error deleted measure and re created and it worked.

Thanks for all your help