https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-expressions-translated-into-the-same-value/m-p/4586245#M175703 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1228402" data-lia-user-login="ProcessENG" class="lia-mention lia-mention-user">ProcessENG</a>&nbsp;You need SWITCH( TRUE(), ... ) Just add TRUE() as your first parameter and then you should be good.</P> Wed, 26 Feb 2025 15:03:55 GMT Greg_Deckler 2025-02-26T15:03:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-expressions-translated-into-the-same-value/m-p/4586191#M175699 <P>I want to be able to create a column that would look at the column [Scrap Reason] and assign a value based on the expression(s) in the [Scrap Reason] column.</P><P><img /></P><P>I've tried the SWITCH function</P><P><img /></P><P>but I get the error</P><P><img /></P><P>I don't think the VALUE or FORMAT functions are going to help me with this, is there some other way to achieve what I am looking for?</P> Wed, 26 Feb 2025 14:39:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-expressions-translated-into-the-same-value/m-p/4586191#M175699 ProcessENG 2025-02-26T14:39:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-expressions-translated-into-the-same-value/m-p/4586245#M175703 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1228402" data-lia-user-login="ProcessENG" class="lia-mention lia-mention-user">ProcessENG</a>&nbsp;You need SWITCH( TRUE(), ... ) Just add TRUE() as your first parameter and then you should be good.</P> Wed, 26 Feb 2025 15:03:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Multiple-expressions-translated-into-the-same-value/m-p/4586245#M175703 Greg_Deckler 2025-02-26T15:03:55Z