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]))
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

kmes40505 i just tested, a table with 3 column and following measure give me count of all rows regardless if user slicer the data from another columns

 

 

Measure = 
VAR x = CALCULATETABLE( ALLSELECTED(  Table1[Column1] ) )
RETURN
COUNTROWS( x )