Key words string values

[Anonymous]

Hey,

(struggling since 2 weeks, I tryed vlookup, summarize function but didn't been able to FIX it) 

I created a culomn with the first "word" of items in my product table, to use as a keyword. 

So actually, I have multiple items having same key word (it is my first objectif). Then I created measures to identify rather an item has a good sell or no.

I wanted to precise that even if an item haven't a good sell but the keyword of this item have a good sell so it's not a problem. So I did same measures by key-word, but when I display the result in separate table with (single table for products column, and single one for key-words) it works, but when I put the results in a single table it gives me results by product items.

I want to be able to summarize the result by key-word for all the products and display the right value in a column.

Thanks to mush for the one that Will help me. 

[Anonymous]

Would be easy with excel, just a Vlookup was sufficient.