Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
4 years ago
Solved

Group by column without duplication

Hi,   I have a one table and it's contain the following columns are Name code, Name and Team.   The Name and Team has duplicate entry against each Name code.   I am trying to get the unique nam...
Need Help
  • SteveHailey's avatar
    SteveHailey
    4 years ago

    Saxon10: Yes, it will. Here is a link to a .pbix file in case it's helpful.

          

     

SteveHailey's avatar
SteveHailey
Solution Specialist
4 years ago

Hi Saxon10.

This is one way:

New Table = 
FILTER( 
    ALL( 'Table'[NAME],'Table'[TEAM] ),
    'Table'[TEAM] <> "NO"
)
  • Saxon10's avatar
    Saxon10
    Post Prodigy
    4 years ago

    SteveHailey,

     

    Thanks for your reply. 

     

    it will give a unique name by team? 

    • SteveHailey's avatar
      SteveHailey
      Solution Specialist
      4 years ago

      Saxon10: Yes, it will. Here is a link to a .pbix file in case it's helpful.

            

       

      • Saxon10's avatar
        Saxon10
        Post Prodigy
        4 years ago

        Thanks for your reply and its working fine.