topic New DAX Measure - return a (unique) value on a field from a selection from another field in DAX Commands and Tips

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

TryingToLearn — Fri, 21 Jul 2023 19:43:06 GMT

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.

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

rubayatyasmin — Fri, 21 Jul 2023 20:03:43 GMT

Hi, TryingToLearn

use selected value, and concatenex

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

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

TryingToLearn — Fri, 21 Jul 2023 20:38:22 GMT

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.

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

ThxAlot — Sat, 22 Jul 2023 11:29:56 GMT

Sold Item.pbix

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

TryingToLearn — Mon, 24 Jul 2023 13:32:27 GMT

Thanks so much, ThxAlot ! Really appreciate it.