Forum Discussion

Milozebre's avatar
Milozebre
Helper V
9 years ago
Solved

Formulas

I need your help to solve a problem. I have tried various solutions that I have read on the forums but that does not help me. I have this kind of data :   Several references belonging to the...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Milozebre,

     

    You can create a calculated table to list all distinct ID, Team values:

     

    Table = SUMMARIZE('Table1',Table1[ID],'Table1'[Team],"Value",MAX('Table1'[NUMBER]))

     

    Then drag that [ID] and [Team] to matrix Row group, [Value] to Values.

     

     

    Best Regards,
    Qiuyun Yu

  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Another option is to use the Query Editors remove duplicates function. Just select the 4 columns and click remove duplicates

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Milozebre,

 

You can create a calculated table to list all distinct ID, Team values:

 

Table = SUMMARIZE('Table1',Table1[ID],'Table1'[Team],"Value",MAX('Table1'[NUMBER]))

 

Then drag that [ID] and [Team] to matrix Row group, [Value] to Values.

 

 

Best Regards,
Qiuyun Yu

Milozebre's avatar
Milozebre
Helper V
9 years ago

Hi v-qiuyu-msft

First thank you for your reply.

 

This is exactly the result I was hoping for.

I hadn't thought of SUMMARIZE :(

I realize that I still have some way to go :)

 

 

A big thank-you