Forum Discussion
Solved
ALLSELECTED with specific column
I'm using multiple slicers. The goal is to select a subtable of one slicer out of the original whole data(not affected by other slicers if the user use any of them) ALLSELECTED('table'[targetColu...
I've modified the column names. was my bad
btw i use table(under visualizations) for other slicers since slicer cannot show multiple values. but for the targetSlicer it is using slicer
Hi kmes40505
Could you give me an example for better analysis?
it is prefered to provide an example data and expected result and actual result.
Best Regards
Maggie
I can't attach an example file here... following is the step to recreate the issue:
1. create a data (excel etc) with
targetSlicer otherSlicer count
choice1 other1 1
choice2 other1 10
choice1 other2 1002. import data into power bi
3. create "slicer" for targetSlicer
4. create "table" for otherSlicer
5. create measure:
TotalCount = CALCULATE(SUM(Sheet1[count]),ALLSELECTED(Sheet1[targetSlicer]))6. create table for TotalCount7. choose "choice1" in targetSlicer. TotalCount should now show 1018. click on one of the value in otherSlicer table. you'll see TotalCount value is changed. which should not happenedThank you