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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors