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,
I have a table like this
Project | Member |
A | Tim |
A | Tess |
A | Jan |
B | Tim |
B | Stan |
C | Jan |
C | Tim |
I want to know
- the posible combinations of members for each project
- how many projects there are for member "Tim" (for example)
- which combinations of members there are when i select a teammember
Thanks for your answer.
Only the last question for the combination for the posible teammembers doesn't work
I made an independent table with "NewTable = DISTINCT(table[members])
After that the measure:
concatenatex(Filter(Table, Table[Member] in allselected(NewTable[Member]) ) , Table[member], " | ")
But this gives the next result
- the posible combinations of members for each project
a measure with project , concatenatex(Table, Table[member], ",")
- how many projects there are for member "Tim" (for example)
count(Table[Project]) with member in visual use filter/slcier for time
- which combinations of members there are when i select a teammember
for that use an independent table having member list
concatenatex(Filter(Table, Table[Memeber] in allselected(Memeber[Memeber]) ) , Table[member], ",")
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |