Forum Discussion

liran's avatar
liran
Frequent Visitor
8 years ago
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

i tried using allexcept but i didnt succeed

any suggestions?

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    liran

     

    May be something like this ....Not sure

     

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

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    liran

     

    May be something like this ....Not sure

     

    Measure =
SUMX (
    FILTER (
        TimeTable,
        TimeTable[Times_DimTime_By_WeeksWeek] = SELECTEDVALUE ( MyfilterTable[Column] )
    ),
    [ValidObservationWeek]
)
    • liran's avatar
      liran
      Frequent Visitor
      8 years ago

      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?