Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Key words string values

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. 

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors