values function with filter

[liran]

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

i tried using allexcept but i didnt succeed

any suggestions?

[Zubair_Muhammad · Accepted solution]

@liran

May be something like this ....Not sure

Measure =
SUMX (
    FILTER (
        TimeTable,
        TimeTable[Times_DimTime_By_WeeksWeek] = SELECTEDVALUE ( MyfilterTable[Column] )
    ),
    [ValidObservationWeek]
)

[liran]

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?

[v-piga-msft]

Hi @liran,

Have you solved your problem?

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[Zubair_Muhammad]

@liran

You can use VALUES or MAX or MIN instead of SELECTEDVALUE as well