single value for repeating values in table

[Anonymous]

I have a table 
ID   Values
1      $
1      $
2      %
2      %

I want to create a measure to display (Group values based on id)
1    $
2    %

[amitchandak]

@Anonymous , if you use the ID in visual then it will.

ID and sum(Table[Value]) in visual that should work

[Anonymous]

I dont want to sum the value. I just want to create a measure to get what value id hold. and that i will use to concat in final o/p
table contains 
id   values   amount
1     $           500
1     $           250
2     %          10
2     %          20
I had created the measure for sum of amount. now i want final output like 
id   o/p
1    750$
2    30% 
like that

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please try the below.

Amount Total with values =
VAR grouptable =
GROUPBY (
Amount,
Amount[id],
"@amounttotal", SUMX ( CURRENTGROUP (), Amount[amount] ),
"@value", MAXX ( CURRENTGROUP (), Amount[values] )
)
RETURN
CONCATENATEX ( grouptable, [@amounttotal] & [@value] )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/