Forum Discussion

PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
6 years ago
Solved

ALLSELECTED on a slicer

Hi,   Is there a way to use AllSelected on a slicer ? I have few slicers on the report and wanted to use the different slicer selections for different tables.   Slicer 1 will filter table 1 Sli...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi, PBIfanatic 

     

    Here is a demo.

    Pbix attached

     

    If  help ,please try steps as below.

    1.duplicate  table  and click "close&apply"

     

    2.Create calculate table as the slicer of table 2

    Table = DISTINCT('financials'[Country])

     

    3. create measure as below to replace the column your mentioned.

    MEASURE COGS2 = CALCULATE(SUM(financials[COGS]),FILTER(CALCULATETABLE(ALLSELECTED('financials'),ALL(financials[Country])),'financials'[Country] in DISTINCT('Table'[Country])))

     

    4.Using edit intractions to achieved the filter context

    it will show as below 

     

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
6 years ago

Hi kentyler ,

thanks, thats definitely an option. 

 

But is there no way we can capture the selections from the slicers (using the same column) in the example I mentioned. 

 

 

kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

I'm not clear.

When you pick a value in slicer 1, and then in slicer 2

do you want the table to be filtered by both values

or do you want to have to tables (displayed) each of which is filtered by a different slicer