Forum Discussion
Solved
Average on Measure
I have a measure to calculate the Rolling Count RollingMeasure = VAR MaxDate = MAX ( 'Date'[Date] ) RETURN CALCULATE ( COUNT(fctTable[ID]), fctTable[HireDate] <= MaxDate, ALL ( Date) )...
Hi hitesh1607,
Have you resolved it? If not, you could reference my way to have a try:
RollingMeasure = CALCULATE ( SUM ( 'Table'[Values] ), FILTER ( ALL ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) && 'Date'[Year] = MAX ( 'Date'[Year] ) ) )Avg = AVERAGEX ( FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Year] = MAX ( 'Date'[Year] ) - 1 ), [RollingMeasure] )If this can't help you, please share some sample data and expected result with us. Thanks.
hitesh1607
Try the Quick Measures: You change the Function within the measure to SUMEX and son on
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply š