Relation problem (Table Visualisation)

[Rayvia]

Hey,

i'm kinda new to Power-BI and i need help with the following problem:

I have these datatables and i want to create a Visualisation in this case a Table and in that Table i want to list all the Buzzwords from each datatable that contains them, but it only allows me to do it for the Membertable + 1 of each datatable, for example i want to create a table with the Buzzwords from Member and UniversityY, that works but as soon as i try to implement the Buzzwords from UniversityX i get an error. I also tried the relationfunction but this doenst work either.

Example from the datatables:

Member

MemberID	Company	buzzword1	buzzword2	buzzword3
1	a	random2	random1
2	b		random4	random1
3	c			random5

Logoagreement:

MemberID	Company	Name
1	a	ab
2	b	ba
3	c	ca

Project:

ProjectID	Project	MemberID	buzzword1	buzzword2	buzzword3
P_01	p1	3	random7	random1
P_02	p2	5
P_03	p3	9		random9

UniversityX:

LaboratoryID	University	MemberID	buzzword1	buzzword2	buzzword3
X_01	xx	4		random5
X_02	xx	4	random1
X_03	xx	4			random2

UniversityY:

LaboratoryID	University	MemberID	buzzword1	buzzword2	buzzword3
Y_01	yy	2	random1		random3
Y_02	yy	2		random2
Y_03	yy	2	random3	random1

The Tables are connected like this:

Member 1:1 logoagreement

Member 1:N Project

Member 1:N UniversityX

Member 1:N UniversityY

[Ashish_Mathur]

Hi,

What result are you expecting.  Show that clearly.

[Rayvia]

I want to create a visualisation in this case a Table that basicly shows every Buzzword from every Table.

The attributes "buzzword" are the same in every datatable, for example buzzword1 would be "renewable energy" so buzzword1 would be "renewable energy" for Member, UniversityX and UniversityY. First i would like to create a table like this bellow and if its possible i would like to combine buzzword1 "renewable energy" so it doesnt show up more than once if thats possible. Value random stands for a word that is in context with the attribute buzzword.

MemberID	Company	Buzzword1(member)	buzzword2(member)	buzzword3(member)	buzzword1(UniversityY)	buzzword2(UniversityY)	buzzword3(UniversityY)	buzzword1(UniversityX)	buzzword3(UniversityX)
1	x	random2	random1		random2			random6
2	y		random3			random1	random5		random7

[v-easonf-msft]

Hi， @Rayvia 

Sorry, your description makes me feel more confused. 

Can you show more detailed table data and explain it?

Best Regards,
Community Support Team _ Eason