unique value in measure column

[Anonymous]

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
3D	18	B	5
3L	91	S	5
3L	91	A	15
3L	91	C	10
AB	58	S	15
AB	58	A	15
FC	38	S	40
YM	74	S	20
YM	74	C	20

when I create a view with just name column I want to get the sum aggregated with only unique values.

Expected o/p is as below

Name	Price
10G	10
11C	12
3D	15
3L	30
AB	15
FC	40
YM	20

Can some one please suggest. Thank you all in advance.

[johnt75 · Accepted solution]

Try

Sum of unique values =
SUMX ( SUMMARIZE ( 'Table', 'Table'[Name], 'Table'[Price] ), 'Table'[Price] )

[Anonymous]

@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]

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

[Anonymous]

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

[Anonymous]

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]

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

[Anonymous]

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

Thank you again the measure works