Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

single value for repeating values in table

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 %

Jihwan_Kim
5 years ago
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/

3 Replies

amitchandak
Super User
5 years ago
Anonymous , if you use the ID in visual then it will.

ID and sum(Table[Value]) in visual that should work
- Anonymous
  Not applicable
  5 years ago
  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
    Super User
    5 years ago
    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/

Related content