cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lucmax
Helper I
Helper I

Performance problem with measure

Hi all,

 

I am trying to get a measure working to get information about the average cumulative duration of sorted data. 

The following two tables are used:

Log:

lucmax_2-1618161091408.png

 

Cases:

lucmax_1-1618160842358.png

 

Expected result in a matrix:

lucmax_3-1618161219158.png

lucmax_5-1618161505017.png

 

 

This works fine with the following when DurationAtStart is the following measure until I work with a big dataset:

DurationAtStart = 
VAR auxT_ =
    ADDCOLUMNS (
        Log,
        "ValueSum_",
            CALCULATE (
                SUM ( Log[duration] ),
                Log[event_number] <= EARLIER ( Log[event_number] ) - 1,
                ALLEXCEPT ( Log, Log[id] )
            )
    )
RETURN
    AVERAGEX ( auxT_, [ValueSum_] )

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.

 

Thank you for your help!

Lucmax

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

lbendlin
Super User III
Super User III

Please provide sample data in usable format (not as a picture).

 

Have you considered using DAX Studio to evaluate the performance of your measure query?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!