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
Super 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 )
kmes40505's avatar
kmes40505
Frequent Visitor
7 years ago

the actual code i use is this:

(all of the following are measure)

 

totalCount = CALCULATE(SUM('table'[count]),ALLSELECTED('table'[targetSlicer]))
 
and later on i want to test for percentage of other slicer(individually) out of the targetSlicer
 
TotalPercentage = SUM('table'[count]) / [totalCount]
but i found out totalCount changes whenever i select other slicer. which should not happen
  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    kmes40505 are you open to share sample data? Your measures have all different columns,

    • kmes40505's avatar
      kmes40505
      Frequent Visitor
      7 years ago

      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

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        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