https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH/m-p/1147181#M17350 <P><SPAN class="hljs-built_in">I tried to use SWITCH</SPAN><SPAN>(&lt;expression&gt;, &lt;</SPAN><SPAN class="hljs-built_in">value</SPAN><SPAN>&gt;, &lt;result&gt;[, &lt;value&gt;, &lt;result&gt;]…[, &lt;else&gt;]) to fulfill the following logic, but failed.</SPAN></P><P>&nbsp;</P><P><SPAN>case</SPAN></P><P><SPAN>when&nbsp;&lt;expression&gt; =&nbsp;&lt;<SPAN class="hljs-built_in">value1</SPAN>&gt; then&nbsp;&lt;result1&gt;</SPAN></P><P><SPAN>when&nbsp;&lt;expression&gt; =&nbsp;&lt;<SPAN class="hljs-built_in">value2</SPAN>&gt; then&nbsp;&lt;result2&gt;</SPAN></P><P><SPAN>....</SPAN></P><P><SPAN>else&nbsp;&lt;expression&gt;</SPAN></P><P>&nbsp;</P> Mon, 08 Jun 2020 15:19:53 GMT Ning_pbi 2020-06-08T15:19:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH/m-p/1147181#M17350 <P><SPAN class="hljs-built_in">I tried to use SWITCH</SPAN><SPAN>(&lt;expression&gt;, &lt;</SPAN><SPAN class="hljs-built_in">value</SPAN><SPAN>&gt;, &lt;result&gt;[, &lt;value&gt;, &lt;result&gt;]…[, &lt;else&gt;]) to fulfill the following logic, but failed.</SPAN></P><P>&nbsp;</P><P><SPAN>case</SPAN></P><P><SPAN>when&nbsp;&lt;expression&gt; =&nbsp;&lt;<SPAN class="hljs-built_in">value1</SPAN>&gt; then&nbsp;&lt;result1&gt;</SPAN></P><P><SPAN>when&nbsp;&lt;expression&gt; =&nbsp;&lt;<SPAN class="hljs-built_in">value2</SPAN>&gt; then&nbsp;&lt;result2&gt;</SPAN></P><P><SPAN>....</SPAN></P><P><SPAN>else&nbsp;&lt;expression&gt;</SPAN></P><P>&nbsp;</P> Mon, 08 Jun 2020 15:19:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH/m-p/1147181#M17350 Ning_pbi 2020-06-08T15:19:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH/m-p/1147208#M17355 <P>problem solved.&nbsp; the dax works, I noticed that I did not clear the filters.&nbsp;</P><P>Thank you.</P> Mon, 08 Jun 2020 15:38:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SWITCH/m-p/1147208#M17355 Ning_pbi 2020-06-08T15:38:41Z