https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-switch-value-based-on-selected-value/m-p/3694533#M143652 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="688932" data-lia-user-login="aprilbanana" class="lia-mention lia-mention-user">aprilbanana</a>&nbsp;, you can achieve this by using parameters in Power BI</P><P>Paramaters can be found under Modelling tab and you can use numeric range and use that in your DAX</P><P><img /></P><P>&nbsp;</P> Mon, 12 Feb 2024 16:50:02 GMT bhanu_gautam 2024-02-12T16:50:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-switch-value-based-on-selected-value/m-p/3694289#M143639 <P>Hello,</P><P>&nbsp;</P><P>How do I switch a value in a different column based on the selected value in my dropdown?</P><P>For example:</P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>Result</TD></TR><TR><TD><FONT color="#0000FF">Banana</FONT></TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>Grape</TD><TD>0</TD></TR><TR><TD>Strawberry&nbsp;</TD><TD>1</TD></TR><TR><TD><P>Apple</P></TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When i get the average of the result column it'll be 25%. If I choose Banana from my slicer, how do I get it to change the result column to 1?</P><P>Results should be:&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>Result</TD></TR><TR><TD><FONT color="#008000">Banana</FONT></TD><TD><FONT color="#008000">1</FONT></TD></TR><TR><TD>Grape</TD><TD>0</TD></TR><TR><TD>Strawberry&nbsp;</TD><TD>1</TD></TR><TR><TD>Apple</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>New average should bt 50%.</P> Mon, 12 Feb 2024 14:45:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-switch-value-based-on-selected-value/m-p/3694289#M143639 aprilbanana 2024-02-12T14:45:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-switch-value-based-on-selected-value/m-p/3694533#M143652 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="688932" data-lia-user-login="aprilbanana" class="lia-mention lia-mention-user">aprilbanana</a>&nbsp;, you can achieve this by using parameters in Power BI</P><P>Paramaters can be found under Modelling tab and you can use numeric range and use that in your DAX</P><P><img /></P><P>&nbsp;</P> Mon, 12 Feb 2024 16:50:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-switch-value-based-on-selected-value/m-p/3694533#M143652 bhanu_gautam 2024-02-12T16:50:02Z