New DAX Measure - return a (unique) value on a field from a selection from another field

[TryingToLearn]

Hello All,

STORE	ITEMS SOLD
A	Electronics, Sporting Goods
B	Sporting Goods
C	Electronics, Sporting Goods, Apparel

Would like to create a new measure for the unique items:

Category

Apparel

Electronics

Sporting Goods

Where selecting the Category value will return the Store(s) that sell the item(s).

For example ---

Selecting Apparel returns Store C

Selecting Electronics returns Store A and Store C

Selecting Sporting Goods returns Store A, Store B, and Store C

I'm new to creating DAX measures. Any help will be greatly appreciated. 

Have a great day and weekend.

[ThxAlot · Accepted solution]

Sold Item.pbix

[TryingToLearn]

Thanks so much, @ThxAlot ! Really appreciate it.

[rubayatyasmin]

Hi, @TryingToLearn 

use selected value, and concatenex

Store By Category =
VAR SelectedCategory = SELECTEDVALUE('Category'[Category])
RETURN
CONCATENATEX(
FILTER('StoreItems', CONTAINSSTRING([Items Sold], SelectedCategory)),
[Store],
", "
)

[TryingToLearn]

Hi @rubayatyasmin,

Thank you for replying to my post. Unfortunately this part is causing issues:

FILTER('StoreItems',

I changed it to 'Store' which is the field name, but the measure is showing a "cannot find the table 'Store'" error.

'Store' and 'Items Sold' fields are on the same table (Store_Table).

Thanks again.