Project members

[Anonymous]

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 

[Anonymous]

@amitchandak 

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 

[amitchandak]

@Anonymous ,

- 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