topic Re: help with the dax expression to calculate depending on dim value ? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3772612#M147410 <P>getting an error. what can be the reason ?</P><P><img /></P><P>&nbsp;</P> Mon, 18 Mar 2024 21:04:47 GMT ashmitp869 2024-03-18T21:04:47Z help with the dax expression to calculate depending on dim value ? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3770016#M147236 <P>Hi all,</P><P>How can I achieve</P><P>when [Service Group Level 0] is "REVENUE" then [Actual Amount]&nbsp;</P><P>when&nbsp; [Service Group Level 0] is "COSTS + OVERHEADS" then [Cost Amount]&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 18 Mar 2024 04:35:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3770016#M147236 ashmitp869 2024-03-18T04:35:08Z Re: help with the dax expression to calculate depending on dim value ? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3772358#M147392 <P>You can use nested IFs, or the syntax sugar version SWITCH.</P> <P>&nbsp;</P> <P>Result = SWITCH([Service Group Level 0],"REVENUE",[Actual Amount],"COSTS + OVERHEADS",[Cost Amount])</P> Mon, 18 Mar 2024 18:09:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3772358#M147392 lbendlin 2024-03-18T18:09:07Z Re: help with the dax expression to calculate depending on dim value ? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3772612#M147410 <P>getting an error. what can be the reason ?</P><P><img /></P><P>&nbsp;</P> Mon, 18 Mar 2024 21:04:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3772612#M147410 ashmitp869 2024-03-18T21:04:47Z Re: help with the dax expression to calculate depending on dim value ? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3772617#M147411 <P>a measure needs an aggregation.&nbsp; use MAX(<SPAN>[Service Group Level 0])&nbsp; , for example.</SPAN></P> Mon, 18 Mar 2024 21:08:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/help-with-the-dax-expression-to-calculate-depending-on-dim-value/m-p/3772617#M147411 lbendlin 2024-03-18T21:08:09Z