Forum Discussion

jdwalker5's avatar
jdwalker5
Icon for Helper II rankHelper II
2 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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's avatar
    jdwalker5
    Icon for Helper II rankHelper II
    2 years ago

    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.