Need a Dax function to get a list of single values out of a group of records

[E12345]

Hi!

I need to select one record out of a group, within a bunch of groups.

How do I do this? I am assuming I need some sort of ranking function or a "top N" function.

Here is a screenshot of what I have, vs. what I need (generally, I need "only one claim out of the group, with the amount".

I have a table of claims with involved parties per claim, and repetitive "Claim Amounts".

There should only be one amount per claim, so I cannot summarize those amounts (they are repetitive). 

I am imagining there should be a ranking function and then to take a record with rank # 1 out of each group. 

it has to be dax only, not a physical table - thanks!  

[Greg_Deckler · Accepted solution]

@E12345 Try:

Table = 
  DISTINCT(
    SELECTCOLUMNS(
      "ClaimantName",[ClaimantName],
      "Claim #",[Claim #],
      "Claim Amount",[Claim Amount]
    )
  )

[Greg_Deckler · Accepted solution]

@E12345 Try:

Table = 
  DISTINCT(
    SELECTCOLUMNS(
      "ClaimantName",[ClaimantName],
      "Claim #",[Claim #],
      "Claim Amount",[Claim Amount]
    )
  )

[E12345 · Accepted solution]

Thank you! So simple! 🙂