https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Key-words-string-values/m-p/2536058#M4540 <P>Would be easy with excel, just a Vlookup was sufficient.&nbsp;</P> Tue, 24 May 2022 11:47:55 GMT Anonymous 2022-05-24T11:47:55Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Key-words-string-values/m-p/2536007#M4539 <P>Hey,</P><P>(struggling since 2 weeks, I tryed vlookup, summarize function but didn't been able to FIX it)&nbsp;</P><P>&nbsp;</P><P>I created a culomn with the first "word" of items in my product table, to use as a keyword.&nbsp;</P><P>&nbsp;</P><P>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.</P><P>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.</P><P>I want to be able to summarize the result by key-word for all the products and display the right value in a column.</P><P>&nbsp;</P><P>Thanks to mush for the one that Will help me.&nbsp;</P> Tue, 24 May 2022 11:32:11 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Key-words-string-values/m-p/2536007#M4539 Anonymous 2022-05-24T11:32:11Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Key-words-string-values/m-p/2536058#M4540 <P>Would be easy with excel, just a Vlookup was sufficient.&nbsp;</P> Tue, 24 May 2022 11:47:55 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Key-words-string-values/m-p/2536058#M4540 Anonymous 2022-05-24T11:47:55Z