Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Would be easy with excel, just a Vlookup was sufficient.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 2 | |
| 2 |