Forum Discussion
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 ...
=SUMX(VALUES(Slicer[Value]),SWITCH(Slicer[Value],1,[Measure1],2,[Measure2],3,[Measure3],0))
=SUMX(VALUES(Slicer[Value]),SWITCH(Slicer[Value],1,[Measure1],2,[Measure2],3,[Measure3],0))
Thank you so much!, exactly what i needed!