https://community.fabric.microsoft.com/t5/Developer/Performance-problem-with-measure/m-p/1783264#M28965 <P>Please provide sample data in usable format (not as a picture).</P> <P>&nbsp;</P> <P>Have you considered using DAX Studio to evaluate the performance of your measure query?</P> Tue, 13 Apr 2021 23:38:36 GMT lbendlin 2021-04-13T23:38:36Z https://community.fabric.microsoft.com/t5/Developer/Performance-problem-with-measure/m-p/1778602#M28891 <P>Hi all,</P><P>&nbsp;</P><P>I am trying to get a measure working to get information about the average cumulative duration of sorted data.&nbsp;</P><P>The following two tables are used:</P><P>Log:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucmax_2-1618161091408.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/492538iE6E6F53FF3E27275/image-size/medium?v=v2&amp;px=400" role="button" title="lucmax_2-1618161091408.png" alt="lucmax_2-1618161091408.png" /></span></P><P>&nbsp;</P><P>Cases:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucmax_1-1618160842358.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/492537i2CC5ED10A5A8741B/image-size/medium?v=v2&amp;px=400" role="button" title="lucmax_1-1618160842358.png" alt="lucmax_1-1618160842358.png" /></span></P><P>&nbsp;</P><P>Expected result in a matrix:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucmax_3-1618161219158.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/492539i34D02FF252105563/image-size/medium?v=v2&amp;px=400" role="button" title="lucmax_3-1618161219158.png" alt="lucmax_3-1618161219158.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lucmax_5-1618161505017.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/492544i9C71BF4396D936D6/image-size/medium?v=v2&amp;px=400" role="button" title="lucmax_5-1618161505017.png" alt="lucmax_5-1618161505017.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>This works fine with the following when DurationAtStart is the following measure until I work with a big dataset:</P><LI-CODE lang="javascript">DurationAtStart = VAR auxT_ = ADDCOLUMNS ( Log, "ValueSum_", CALCULATE ( SUM ( Log[duration] ), Log[event_number] &lt;= EARLIER ( Log[event_number] ) - 1, ALLEXCEPT ( Log, Log[id] ) ) ) RETURN AVERAGEX ( auxT_, [ValueSum_] )</LI-CODE><P>Do you any tips on how I can change the measure so everything works faster? Right now on a bigger dataset it stops calculating because the memory limit will get reached. I don't want to pre calculate everything unless it really is the last option.</P><P>&nbsp;</P><P>Thank you for your help!</P><P>Lucmax</P> Sun, 11 Apr 2021 17:19:03 GMT https://community.fabric.microsoft.com/t5/Developer/Performance-problem-with-measure/m-p/1778602#M28891 lucmax 2021-04-11T17:19:03Z https://community.fabric.microsoft.com/t5/Developer/Performance-problem-with-measure/m-p/1783264#M28965 <P>Please provide sample data in usable format (not as a picture).</P> <P>&nbsp;</P> <P>Have you considered using DAX Studio to evaluate the performance of your measure query?</P> Tue, 13 Apr 2021 23:38:36 GMT https://community.fabric.microsoft.com/t5/Developer/Performance-problem-with-measure/m-p/1783264#M28965 lbendlin 2021-04-13T23:38:36Z https://community.fabric.microsoft.com/t5/Developer/Performance-problem-with-measure/m-p/1786078#M29005 <P>You can refer to this blog:</P><P><A href="https://maqsoftware.com/expertise/powerbi/dax-best-practices" target="_self">https://maqsoftware.com/expertise/powerbi/dax-best-practices</A>&nbsp;</P> Thu, 15 Apr 2021 06:46:18 GMT https://community.fabric.microsoft.com/t5/Developer/Performance-problem-with-measure/m-p/1786078#M29005 V-lianl-msft 2021-04-15T06:46:18Z