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

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    liran

     

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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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