Optimizing Performance for my Local Measure

lsolomon1 — Mon, 29 Apr 2019 16:05:14 GMT

Below you will see my bread crumb trail of measures that make up my main measure *_Monthly At Risk Units in which I am trying to help with the duration of the load time. It currently takes 11 seconds and I am trying to understand how I can improve it.

The colors explained - Yellow is my main measure. Pink is the measure referenced in the yellow measure. Gray measures are the ones used in the pink, and olive green within the gray. Let me know if you have any ideas on a DAX formatting change or a different way I could do this.

*_Monthly At Risk Units = var RiskUntis = [*_Availability by Month]

Return

IF([*_Availability by Month]<0,[*_Availability by Month])

*_Availability by Month = ATP[*_Rolling Total ATP] - [*_Rolling Total At Once Master]

*_Rolling Total ATP =

CALCULATE([*_ATP (TA)],

FILTER(

ALL(

'Common Days TA'),

'Common Days TA'[YearMonth] <= MAX('Common Days TA'[YearMonth])))

*_Rolling Total At Once Master =

SUMX (

FILTER (

ALLSELECTED ( 'Common Days TA'[YearMonth] ),

'Common Days TA'[YearMonth] <= MAX ( 'Common Days TA'[YearMonth] )

[*_At Once Master (TA)]

)

*_ATP (TA) =

CALCULATE(

[*_ATP Units],

TREATAS(VALUES('Common Days TA'[DateKey]), 'Event Date'[DateKey])

)

*_At Once Master (TA) = CALCULATE([*_At Once Master],

TREATAS(VALUES('Common Days TA'[DateKey]), 'Event Date'[DateKey]))

topic Optimizing Performance for my Local Measure in Developer

Optimizing Performance for my Local Measure