Forum Discussion

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper 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

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago
Hi Milozebre,

Do a distincr count on ID and you will get what you need.

Regards,

MFelix
  • Milozebre's avatar
    Milozebre
    Icon for Helper V rankHelper V
    9 years ago

    HI MFelix, 

     

    Thank you for your reply.

    I have already tried but it doesn't work.

     

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      9 years ago
      The distinct count was done in the ID column or on the nber column?