Forum Discussion
Solved
values function with filter
hi, i have this measure: SUMX ( VALUES ( TimeTable[Times_DimTime_By_WeeksWeek] ), [ValidObservationWeek] ) and i want it to sum only when the period is equal to the period in my filter ...
May be something like this ....Not sure
Measure = SUMX ( FILTER ( TimeTable, TimeTable[Times_DimTime_By_WeeksWeek] = SELECTEDVALUE ( MyfilterTable[Column] ) ), [ValidObservationWeek] )
it says that 'SELECTEDVALUE'. It is not a valid table, variable, or function name.
i'm using excel 2016, maybe this version doesnt support the SELECTEDVALUE function?