Forum Discussion

kmes40505's avatar
kmes40505
Frequent Visitor
7 years ago
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...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    kmes40505 your measure should be

     

    TotalCount = CALCULATE(SUM(Sheet1[count]),ALLEXCEPT(Sheet1, Sheet1[targetSlicer]))
kmes40505's avatar
kmes40505
Frequent Visitor
7 years ago

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            100

2. 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 TotalCount
7. choose "choice1" in targetSlicer. TotalCount should now show 101
8. click on one of the value in otherSlicer table. you'll see TotalCount value is changed. which should not happened
 
Thank you
parry2k's avatar
parry2k
Super User
7 years ago

kmes40505 your measure should be

 

TotalCount = CALCULATE(SUM(Sheet1[count]),ALLEXCEPT(Sheet1, Sheet1[targetSlicer]))