How to show only specific team members? *Newbie Looking for Help*

[TapZxK]

Hi Team, 

yet another rookie question. 

I'm looking to return names of people who are in a specific team. I'm sure there is a DAX to do it but I can't figure it out. 

I have a table that lists names of people and also their team. 

Member Name // Team Name

Jon                             A

Anna                          A

Stefan                        B

Mike                          A

Stuart                         B

Juliett                         B

Romeo                       A

Cookie Monster          B

I want to create a Table in Power BI that will return show names of People in Team A and ignore the rest. 

Thank you. 

BR,

Kris

[v-easonf-msft]

Hi , @TapZxK 

Try to create a calculate table :

Table 2 = CALCULATETABLE('Table','Table'[Team Name]="A")

And it shows as below:

Here is a sample :

 Pbix  

Best Regards,
Community Support Team _ Eason

[Mariusz]

Hi @TapZxK 

Please see the below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Greg_Deckler]

Try:

Table 2 = FILTER('Table',[Team Name] = "A")

[Anonymous]

so based on your filter you want to have something like "Jon, Anna, Mike"?

If so, use CONCATENATEX but better clarify your needs.

[TapZxK]

Hi, 

exactly. 

I don't need to see their teams. 

I just want for a visuzalization table to return all the names of people who are in the Team A withou actually shoing the team. 

I need this because I am preparing 2 Reporting pages in Power BI. One for TEAM A and another for TEAM B. 

I dont need to specify that Ana is in team A. 

I just need that People who belong to Team A are displayed on the TEAM A Page within Power BI.

[Greg_Deckler · Accepted solution]

OK, try this:

Measure = 
  CONCATENATEX(
    SELECTCOLUMNS(
      FILTER('Table',[Team Name] = "A"),
      "Name",[Member/Name]
    ),
    [Name],","
  )

[Anonymous]

I do understand that you're a newbie, all of us have been newbies, but I do STRONGLY recommend taking a basic course in PBI and DAX. There's plenty of it on the web, for free. Your question is so basic that you're risking to show incorrect data at the next iteration of your report. 

[az38]

Hi @TapZxK 

just set filter visual in filter pane as team name = A