How to get correct value selected by the slicer

[PbiCeo]

Hello everyone,

I want to display values on Matrix selected by the slicer.

Here is Table1.

Selection

Group

Product1

Product2

Division

Person

and Table2.

Num	Data	Group	Product1	Product2	Division	Person
1	A	1	1	a	C	A1
2	A	2	3	a	C	A1
3	A	3	2	a	B	B1
4	B	1	5	a	B	A1
5	B	2	4	b	A	B1
6	B	3	2	b	A	A1
7	C	1	1	b	A	B1
8	C	2	3	b	B	A1
9	C	3	5	b	C	B1

There is no relationship between them.

For slicer selection, I created a measure like this:

SelectedValue = SELECTEDVALUE(Table1[Selection])

Moreover, measure to get value selected by the slicer:

Measure = SWITCH([SelectedValue],

"Group", DISTINCT('Table2'[Group]),

"Product1", DISTINCT('Table2'[Product1]),

"Product2", DISTINCT('Table2'[Product2]),

"Division", DISTINCT('Table2'[Division]),

"Person", DISTINCT('Table2'[Person]),

BLANK()

)

But I got an error when I selected a value from above "Selection" on the slicer:

MdxScript (Model) (9, 13) Calculation error in measure 'Table2'[Measure]: a table of multiple values was supplied where a single value was expected.

 

I want to disptaly each distinct corresponding value.

How to correct that?

Thank you,

Vadi

[Greg_Deckler]

@PbiCeo Right, DISTINCT returns a table of values which is not valid for measures. Often you use CONCATENATEX to do something like returning a single value from a table of values. If that does not suffice Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.