Forum Discussion
Detected Value From Column Which Has Comma As Split
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.
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
2 Replies
- amitchandak
Super User
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-ad2f9783ffa2Thank you so much! Have a nice day!
