Group by column without duplication

[Saxon10]

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. 

 

[SteveHailey]

Hi @Saxon10.

This is one way:

New Table = 
FILTER( 
    ALL( 'Table'[NAME],'Table'[TEAM] ),
    'Table'[TEAM] <> "NO"
)

[Saxon10]

@SteveHailey,

Thanks for your reply. 

it will give a unique name by team? 

[SteveHailey · Accepted solution]

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

      

[Saxon10]

Thanks for your reply and its working fine.