Detected Value From Column Which Has Comma As Split

[ffirda99]

Hello everyone,

I have two database,

Database1

Labor	Job	Part	No Part	Length
Ara	A21	Body	1	200
Ara	A21	Body	2	200
Ara	A21	Head	2	150
Kiano	A21	Head	1	300
Kiano	A21	Body	2	200
Kiano	A21	Body	3	400
Edi	A21	Body	3	400
Edi	A21	Body	4	180
Fahri	B25	Head	1	200
Fahri	B25	Body	1	250
Fahri	B25	Head	2	350
Kiano	B25	Head	2	350
Kiano	B25	Head	3	100

Database2

Inspector	Labor	Job	Part	No Part	Length	Result	Defect	Length (Done)
Dino	Ara	A21	Body	1	200	ACC	-	200
Dino	Ara;Kiano	A21	Body	2	200	Repair	Crack;Oversize	100
Dino	Ara	A21	Head	2	150	ACC	-	150
Dino	Kiano	A21	Head	1	300	Repair	Underfill	300
Dino	Kiano;Edi	A21	Body	3	400	ACC	-	200
Dino	Edi	A21	Body	4	180	ACC	-	180
Mario	Fahri	B25	Head	1	200	Repair	Undersize;Spatter	200
Mario	Fahri	B25	Body	1	250	ACC	-	250
Mario	Fahri;Kiano	B25	Head	2	350	Repair	Crack	175
Mario	Kiano	B25	Head	3	100	ACC	-	100

I make Slicer(Labor, database1) and Card (Length(done), database2). I already make a data connection. 

But, when I choose 'Ara' from Slicer, the card value is 350. I want the value 450, because there is the name Ara in the second row, database2.

How to do it? Thank you in advance.

[amitchandak · Accepted solution]

@ffirda99 , On the way is deal with that split column by delimiter in power query and then join

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

If database 1 table is not master, consider this approach to have common master for both tables

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

[ffirda99]

Thank you so much! Have a nice day!