Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
OK, try this:
Measure =
CONCATENATEX(
SELECTCOLUMNS(
FILTER('Table',[Team Name] = "A"),
"Name",[Member/Name]
),
[Name],","
)
Try:
Table 2 = FILTER('Table',[Team Name] = "A")
so based on your filter you want to have something like "Jon, Anna, Mike"?
If so, use CONCATENATEX but better clarify your needs.
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.
OK, try this:
Measure =
CONCATENATEX(
SELECTCOLUMNS(
FILTER('Table',[Team Name] = "A"),
"Name",[Member/Name]
),
[Name],","
)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |