Forum Discussion
Solved
Measure to calculate value based on filter
Hello, I'm trying to create a measure to calculate a value that is filtered to current year that I can use in a line chart to see results over a 52 week period. This is not working: CURR...
jdwalker5 , Try like
CURRENT_YEAR_CALCULATION =
VAR CUR_YR = MAXX(allselected('DATA'), 'DATA'[YEAR_NBR])
VAR CALC = CALCULATE(
DIVIDE('DATA'[NUMERATOR], 'DATA'[DENOMINATOR]),
'DATA'[YEAR_NBR] = CUR_YR
)
RETURN CALC
jdwalker5 , Try like
CURRENT_YEAR_CALCULATION =
VAR CUR_YR = MAXX(allselected('DATA'), 'DATA'[YEAR_NBR])
VAR CALC = CALCULATE(
DIVIDE('DATA'[NUMERATOR], 'DATA'[DENOMINATOR]),
'DATA'[YEAR_NBR] = CUR_YR
)
RETURN CALC
That's the ticket! Thanks for you your help amitchandak.
FYI, I was able to get it to work by creating a custom column using MAX('DATE'[YEAR]), but I prefer to use your solution.
