topic SWITCH INTO SWITCH in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH-INTO-SWITCH/m-p/835826#M6189 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I dont know why this is happening..</P><P>&nbsp;</P><P>The error says: "The ALLSELECTED function expects a table reference expression for argument '2', but a string or numeric"</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P> Mon, 04 Nov 2019 05:08:09 GMT Anonymous 2019-11-04T05:08:09Z SWITCH INTO SWITCH https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH-INTO-SWITCH/m-p/835826#M6189 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I dont know why this is happening..</P><P>&nbsp;</P><P>The error says: "The ALLSELECTED function expects a table reference expression for argument '2', but a string or numeric"</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P> Mon, 04 Nov 2019 05:08:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH-INTO-SWITCH/m-p/835826#M6189 Anonymous 2019-11-04T05:08:09Z Re: SWITCH INTO SWITCH https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH-INTO-SWITCH/m-p/836012#M6193 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>&nbsp;</P> <P>What are you trying to achieve here?</P> <P>ALLSELECT accepts only tables and columns as arguments, in your second ALLSELECT you are missing ")"</P> <P>&nbsp;</P> <DIV>Best Regards,<BR />Mariusz<BR /><BR />If this post <STRONG>helps</STRONG>, then please consider <STRONG><I>Accepting it as the solution</I></STRONG>.<BR /><BR />Please feel free to connect with me.<BR /><A href="https://www.linkedin.com/in/mariusz-repczynski-065a7362/" rel="nofollow noopener noreferrer" target="_blank"><IMG src="https://ip1.i.lithium.com/1232d707bb27fc4afa3b81cd0702c478b6f7aced/68747470733a2f2f7374617469632e6c6963646e2e636f6d2f736364732f636f6d6d6f6e2f752f696d616765732f6c6f676f732f6c696e6b6564696e2f6c6f676f5f6c696e6b6564696e5f39337832315f76322e706e67" border="0" alt="Mariusz Repczynski" /></A></DIV> <P>&nbsp;</P> Mon, 04 Nov 2019 08:27:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH-INTO-SWITCH/m-p/836012#M6193 Mariusz 2019-11-04T08:27:59Z