Forum Discussion
Measure loads slowly
Hi Community, I built a power bi that includes a measure for a rolling 5-day average. This rolling average can only include volume from non-weekends and non-holidays. I've gotten it to calculate ...
Anonymous Maybe try:
Rolling 5 day average_business days only = VAR TopRank = min(DateDim[Business days index]) Var RankUL = TopRank+5 VAR RollingSum = CALCULATE SUM([Total Visits]), filter( ALLSELECTED('Visit Details'), 'Visit Details'[Business day index] < RankUL && 'Visit Details'[Business day index] >= TopRank), ) Return Divide(RollingSum,5)
Anonymous - Curious, how much did that speed things up?
My data set is pretty large so the change was significant. I went from about 2 minutes to load the graph to about 1 second. Thanks again!