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] )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

johnt75 

In my real time data the price column is coming from different table and it is not allowing to call price in the calculation any suggestions please

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