Forum Discussion
Cumulative daily average in selected range
- 4 years ago
Nice! Thanks. It almost worked, although close enough. I had to switch ALL to ALLSELECTED, like so:
From:
Process Score = CALCULATE( CALCULATE(
AVERAGE(fact__scores[Process score]),
USERELATIONSHIP(dim_Calendar[date],fact_scores[Handle Date])
), Filter(all(dim_Calendar) , dim_Calendar[date] <= max(dim_Calendar[date]) ) )
To:
Process Score = CALCULATE( CALCULATE(
AVERAGE(fact__scores[Process score]),
USERELATIONSHIP(dim_Calendar[date],fact_scores[Handle Date])
), Filter( ALLSELECTED(dim_Calendar) , dim_Calendar[date] <= max(dim_Calendar[date]) ) )
End result:
If you want to update the answer, I will mark it as the solution.
Luggruff , try like
Process Score = CALCULATE( CALCULATE(
AVERAGE(fact__scores[Process score]),
USERELATIONSHIP(dim_Calendar[date],fact_scores[Handle Date])
), Filter( all(dim_Calendar) , dim_Calendar[date] <= max(dim_Calendar[date]) ) )
- Luggruff4 years agoFrequent Visitor
Nice! Thanks. It almost worked, although close enough. I had to switch ALL to ALLSELECTED, like so:
From:
Process Score = CALCULATE( CALCULATE(
AVERAGE(fact__scores[Process score]),
USERELATIONSHIP(dim_Calendar[date],fact_scores[Handle Date])
), Filter(all(dim_Calendar) , dim_Calendar[date] <= max(dim_Calendar[date]) ) )
To:
Process Score = CALCULATE( CALCULATE(
AVERAGE(fact__scores[Process score]),
USERELATIONSHIP(dim_Calendar[date],fact_scores[Handle Date])
), Filter( ALLSELECTED(dim_Calendar) , dim_Calendar[date] <= max(dim_Calendar[date]) ) )
End result:
If you want to update the answer, I will mark it as the solution.