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
Super 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
      Super 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

  • 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
      Super 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