Forum Discussion
ewkcoder
2 years agoFrequent Visitor
ALLSELECTED with interactions turned on
Problem: I am trying to calculate a column based on the multiple selections in one slicer. There are many slicers on page. Project: Report Page 1: I allow users to select from a slicer a list...
ewkcoder
2 years agoFrequent Visitor
Adding more description to what I am looking to accomplish.
#1) Allow users to pick from a list of data.
#2) Display data on a table for basic comparison.
#3) Allow the user to click a button to another report page that preserves their original selections and displays all of their selections in three different multi select slicers. Users can now create groups of the original records they selected for comparison against one another.
#4) User clicks next button and on this page I want to compare the groups against eachother.
To accomplish this I created three clones of the column being used to fill each slicer. From here I want to now write measures where I can isolate the records selected in each of the slicers.