topic How to get correct value selected by the slicer in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-correct-value-selected-by-the-slicer/m-p/1095904#M15973 <P>Hello everyone,<BR /><BR /></P><P>I want to display values on Matrix selected by the slicer.</P><P>Here is Table1.</P><TABLE><TBODY><TR><TD>Selection</TD></TR><TR><TD>Group</TD></TR><TR><TD>Product1</TD></TR><TR><TD>Product2</TD></TR><TR><TD>Division</TD></TR><TR><TD>Person</TD></TR></TBODY></TABLE><P><BR />and Table2.</P><TABLE><TBODY><TR><TD>Num</TD><TD>Data</TD><TD>Group</TD><TD>Product1</TD><TD>Product2</TD><TD>Division</TD><TD>Person</TD></TR><TR><TD>1</TD><TD>A</TD><TD>1</TD><TD>1</TD><TD>a</TD><TD>C</TD><TD>A1</TD></TR><TR><TD>2</TD><TD>A</TD><TD>2</TD><TD>3</TD><TD>a</TD><TD>C</TD><TD>A1</TD></TR><TR><TD>3</TD><TD>A</TD><TD>3</TD><TD>2</TD><TD>a</TD><TD>B</TD><TD>B1</TD></TR><TR><TD>4</TD><TD>B</TD><TD>1</TD><TD>5</TD><TD>a</TD><TD>B</TD><TD>A1</TD></TR><TR><TD>5</TD><TD>B</TD><TD>2</TD><TD>4</TD><TD>b</TD><TD>A</TD><TD>B1</TD></TR><TR><TD>6</TD><TD>B</TD><TD>3</TD><TD>2</TD><TD>b</TD><TD>A</TD><TD>A1</TD></TR><TR><TD>7</TD><TD>C</TD><TD>1</TD><TD>1</TD><TD>b</TD><TD>A</TD><TD>B1</TD></TR><TR><TD>8</TD><TD>C</TD><TD>2</TD><TD>3</TD><TD>b</TD><TD>B</TD><TD>A1</TD></TR><TR><TD>9</TD><TD>C</TD><TD>3</TD><TD>5</TD><TD>b</TD><TD>C</TD><TD>B1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>There is no relationship between them.</P><P><BR />For slicer selection, I created a measure like this:</P><DIV><DIV><SPAN>SelectedValue = SELECTEDVALUE(Table1[Selection])<BR /><BR />Moreover, measure to get value selected by the slicer:</SPAN></DIV><DIV><DIV><DIV><SPAN>Measure = SWITCH([SelectedValue],</SPAN></DIV><DIV><SPAN>"Group", DISTINCT('Table2'[Group]),</SPAN></DIV><DIV><SPAN>"Product1", DISTINCT('Table2'[Product1]),</SPAN></DIV><DIV><SPAN>"Product2", DISTINCT('Table2'[Product2]),</SPAN></DIV><DIV><SPAN>"Division", DISTINCT('Table2'[Division]),</SPAN></DIV><DIV><SPAN>"Person", DISTINCT('Table2'[Person]), </SPAN></DIV><DIV><SPAN>BLANK()</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But I got an error when I selected a value from above "Selection" on the slicer:</SPAN></DIV><DIV><SPAN>MdxScript (Model) (9, 13) Calculation error in measure 'Table2'[Measure]: a table of multiple values was supplied where a single value was expected.</SPAN></DIV></DIV><SPAN>&nbsp;<BR /></SPAN></DIV><DIV><SPAN>I want to disptaly each distinct corresponding value.</SPAN></DIV><DIV><SPAN>How to correct that?</SPAN></DIV><DIV><SPAN>Thank you,</SPAN></DIV><DIV><SPAN>Vadi</SPAN></DIV></DIV> Tue, 19 May 2020 09:24:00 GMT PbiCeo 2020-05-19T09:24:00Z How to get correct value selected by the slicer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-correct-value-selected-by-the-slicer/m-p/1095904#M15973 <P>Hello everyone,<BR /><BR /></P><P>I want to display values on Matrix selected by the slicer.</P><P>Here is Table1.</P><TABLE><TBODY><TR><TD>Selection</TD></TR><TR><TD>Group</TD></TR><TR><TD>Product1</TD></TR><TR><TD>Product2</TD></TR><TR><TD>Division</TD></TR><TR><TD>Person</TD></TR></TBODY></TABLE><P><BR />and Table2.</P><TABLE><TBODY><TR><TD>Num</TD><TD>Data</TD><TD>Group</TD><TD>Product1</TD><TD>Product2</TD><TD>Division</TD><TD>Person</TD></TR><TR><TD>1</TD><TD>A</TD><TD>1</TD><TD>1</TD><TD>a</TD><TD>C</TD><TD>A1</TD></TR><TR><TD>2</TD><TD>A</TD><TD>2</TD><TD>3</TD><TD>a</TD><TD>C</TD><TD>A1</TD></TR><TR><TD>3</TD><TD>A</TD><TD>3</TD><TD>2</TD><TD>a</TD><TD>B</TD><TD>B1</TD></TR><TR><TD>4</TD><TD>B</TD><TD>1</TD><TD>5</TD><TD>a</TD><TD>B</TD><TD>A1</TD></TR><TR><TD>5</TD><TD>B</TD><TD>2</TD><TD>4</TD><TD>b</TD><TD>A</TD><TD>B1</TD></TR><TR><TD>6</TD><TD>B</TD><TD>3</TD><TD>2</TD><TD>b</TD><TD>A</TD><TD>A1</TD></TR><TR><TD>7</TD><TD>C</TD><TD>1</TD><TD>1</TD><TD>b</TD><TD>A</TD><TD>B1</TD></TR><TR><TD>8</TD><TD>C</TD><TD>2</TD><TD>3</TD><TD>b</TD><TD>B</TD><TD>A1</TD></TR><TR><TD>9</TD><TD>C</TD><TD>3</TD><TD>5</TD><TD>b</TD><TD>C</TD><TD>B1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>There is no relationship between them.</P><P><BR />For slicer selection, I created a measure like this:</P><DIV><DIV><SPAN>SelectedValue = SELECTEDVALUE(Table1[Selection])<BR /><BR />Moreover, measure to get value selected by the slicer:</SPAN></DIV><DIV><DIV><DIV><SPAN>Measure = SWITCH([SelectedValue],</SPAN></DIV><DIV><SPAN>"Group", DISTINCT('Table2'[Group]),</SPAN></DIV><DIV><SPAN>"Product1", DISTINCT('Table2'[Product1]),</SPAN></DIV><DIV><SPAN>"Product2", DISTINCT('Table2'[Product2]),</SPAN></DIV><DIV><SPAN>"Division", DISTINCT('Table2'[Division]),</SPAN></DIV><DIV><SPAN>"Person", DISTINCT('Table2'[Person]), </SPAN></DIV><DIV><SPAN>BLANK()</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But I got an error when I selected a value from above "Selection" on the slicer:</SPAN></DIV><DIV><SPAN>MdxScript (Model) (9, 13) Calculation error in measure 'Table2'[Measure]: a table of multiple values was supplied where a single value was expected.</SPAN></DIV></DIV><SPAN>&nbsp;<BR /></SPAN></DIV><DIV><SPAN>I want to disptaly each distinct corresponding value.</SPAN></DIV><DIV><SPAN>How to correct that?</SPAN></DIV><DIV><SPAN>Thank you,</SPAN></DIV><DIV><SPAN>Vadi</SPAN></DIV></DIV> Tue, 19 May 2020 09:24:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-correct-value-selected-by-the-slicer/m-p/1095904#M15973 PbiCeo 2020-05-19T09:24:00Z Re: How to get correct value selected by the slicer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-correct-value-selected-by-the-slicer/m-p/1095931#M15975 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="231641" data-lia-user-login="PbiCeo" class="lia-mention lia-mention-user">PbiCeo</a>&nbsp;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&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: <A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A><BR /><BR />The most important parts are:<BR />1. Sample data as text, use the table tool in the editing bar<BR />2. Expected output from sample data<BR />3. Explanation in words of how to get from 1. to 2.</P> Tue, 19 May 2020 09:33:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-correct-value-selected-by-the-slicer/m-p/1095931#M15975 Greg_Deckler 2020-05-19T09:33:04Z