Help with Dax

[vjnvinod]

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]))

[Tahreem24 · Accepted solution]

@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])))

[vjnvinod]

@Tahreem24 

awesome, worked like a charm

[PVO3]

I think you need to change this.

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

[amitchandak]

@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  ))