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. 

 

 

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.

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi , PBIfanatic 

      Sorry, this is the only solution I think of at the moment.

      Hope others can come up with better solutions

       

      Best Regards,
      Community Support Team _ Eason