Forum Discussion

BIuser09's avatar
BIuser09
Icon for Helper I rankHelper I
2 years ago
Solved

apply slicer values in virtual table

Hi, I would like to have a measure obtaining a virtual table where all my slicers (15) selections or non-selections are applied to. With this filtered table, I still have to perform several actions ...
DAX
SUMMARIZE
Virtual Table
  • lbendlin's avatar
    lbendlin
    2 years ago

    Instead of SELECTEDVALUE use VALUES.  Learn about TREATAS too.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Instead of SELECTEDVALUE use VALUES.  Learn about TREATAS too.

BIuser09's avatar
BIuser09
Icon for Helper I rankHelper I
2 years ago

thanks ! using VALUES to capture slicer selection(s) solved it.

However, they have to be defined in top of measure as variables, not to use directly in SUMMARIZE function