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 name by team from the Table by using "New Table " option.

 

I am trying to apply the following DAX =summarize(Table, Table (Name), Table (Team), "Filter not equal to no", Table (Team) <>"No" but its not filter the column but its return true or false.

 

I want to ignore the "No" columns row from the table. I trying to get the unique Name by Team from the table.

 

Any suggestions that would be great. 

 

Thank you. 

 

Need Help

4 Replies

  • 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"
)