Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
4 years ago
Solved

Help with Dax

Dear all,

 

my below formula is returning an error

 

This formula is invalid or incomplete: 'The expression is not valid or appears to be incomplete. Please review and correct the expression.
The end of the input was reached.
'.

 

Avg Fte=CALCULATE(SUM('Flash WTD'[Avg FTE]),FILTER('Flash WTD',MAX('Flash WTD'[Index]))

Need Help
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    vjnvinod  You should try something like below and also you need to add one more bracket at the end to make it complete.

    Avg Fte=CALCULATE(SUM('Flash WTD'[Avg FTE]),FILTER('Flash WTD','Flash WTD'[Index]=MAX('Flash WTD'[Index])))

     

4 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    vjnvinod  You should try something like below and also you need to add one more bracket at the end to make it complete.

    Avg Fte=CALCULATE(SUM('Flash WTD'[Avg FTE]),FILTER('Flash WTD','Flash WTD'[Index]=MAX('Flash WTD'[Index])))

     

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    vjnvinod , what are you trying here

     

    one option

    Avg Fte=CALCULATE(SUM('Flash WTD'[Avg FTE]),FILTER(allselected('Flash WTD') ,'Flash WTD'[Index] = MAX('Flash WTD'[Index])))

     

    Second option

    Avg Fte=

    var _max = maxx(allselected('Flash WTD') ,'Flash WTD'[Index] )

    return

    CALCULATE(SUM('Flash WTD'[Avg FTE]),FILTER(('Flash WTD') ,'Flash WTD'[Index] = _max  ))

  • PVO3's avatar
    PVO3
    Impactful Individual
    4 years ago

    I think you need to change this.

    MAX('Flash WTD'[Index]) = xxx