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 for your reply. 

I meant table visualization, there is just 1 table in the data model. 

 

I wanted to do comparitive analysis, so I need to replicate the slicers and tables and then make different selections on the slicers.

 

thanks.

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

If you go to Power Query you can make a "reference" copy of the table, which should not be affected by slicers you put on the first table, and you should be able to "slice" the reference table independently

  • 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. 

     

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      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 v-easonf-msft ,

         

        Thanks for your reply and the attachment. 

        I can use this in my current model.

         

        But is there any way we can refer to the slicers without duplicating the tables or creating references?

         

        Is there a way we can use the slicer names in DAX?

         

        thanks.

    • 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