https://community.fabric.microsoft.com/t5/Developer/Memory-Error-with-simple-SUM-measures/m-p/3170446#M42053 <P>Hello,</P><P>Last week an user had an error on a report that only compares real turnover with budget.&nbsp; My model has two different currencies, one in local currency and one in USD.&nbsp; Both fact tables, sales and budget has two columns for each currency, so all I needed to do was create the measures as SUM(Sales LC) and SUM(Sales USD). Then, the user can choose wich currency need to see. For this I made a measure with a SWITCH statement</P><P>The problem is that the measure in USD takes until 3x times that the LC.&nbsp; But it is just the column next to the other one!<BR />I thought the problem was the SWICTH, but then I performed some tests in Dax Studio, only with the SUM measures and the behaviour is as I say, one SUM is much slower than the other<BR />I also checked the datatypes and both are decimal</P><P>Regards</P> Mon, 03 Apr 2023 23:53:59 GMT Anonymous 2023-04-03T23:53:59Z https://community.fabric.microsoft.com/t5/Developer/Memory-Error-with-simple-SUM-measures/m-p/3170446#M42053 <P>Hello,</P><P>Last week an user had an error on a report that only compares real turnover with budget.&nbsp; My model has two different currencies, one in local currency and one in USD.&nbsp; Both fact tables, sales and budget has two columns for each currency, so all I needed to do was create the measures as SUM(Sales LC) and SUM(Sales USD). Then, the user can choose wich currency need to see. For this I made a measure with a SWITCH statement</P><P>The problem is that the measure in USD takes until 3x times that the LC.&nbsp; But it is just the column next to the other one!<BR />I thought the problem was the SWICTH, but then I performed some tests in Dax Studio, only with the SUM measures and the behaviour is as I say, one SUM is much slower than the other<BR />I also checked the datatypes and both are decimal</P><P>Regards</P> Mon, 03 Apr 2023 23:53:59 GMT https://community.fabric.microsoft.com/t5/Developer/Memory-Error-with-simple-SUM-measures/m-p/3170446#M42053 Anonymous 2023-04-03T23:53:59Z https://community.fabric.microsoft.com/t5/Developer/Memory-Error-with-simple-SUM-measures/m-p/3171584#M42068 <P>Hi&nbsp;@Anonymous&nbsp;, could you provide some sample of the data, or screenshots of the measures, columns, or Dax Studio outputs?</P><P><BR />If you need any additional help please <SPAN>@</SPAN> me in your reply.</P> Tue, 04 Apr 2023 11:37:18 GMT https://community.fabric.microsoft.com/t5/Developer/Memory-Error-with-simple-SUM-measures/m-p/3171584#M42068 joaoribeiro 2023-04-04T11:37:18Z