Forum Discussion

Red217's avatar
Red217
Icon for Helper III rankHelper III
5 years ago
Solved

Using a slicer to select multiple values

Hello,  i have been using Slicers with SELECTEDVALUE and SWITCH to select different measurements based on the slicer selection, works great BUT, can only make it work for 1 selection.   in my cas ...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    =SUMX(VALUES(Slicer[Value]),SWITCH(Slicer[Value],1,[Measure1],2,[Measure2],3,[Measure3],0))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

=SUMX(VALUES(Slicer[Value]),SWITCH(Slicer[Value],1,[Measure1],2,[Measure2],3,[Measure3],0))

Red217's avatar
Red217
Icon for Helper III rankHelper III
5 years ago

Thank you so much!, exactly what i needed!