Forum Discussion

klehar's avatar
klehar
Helper V
2 years ago
Solved

Changing context

    This is my data. I want that despite users selecting anything from the Geo filter, my sales should continue to show all Geos Where am i going wrong?  
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi klehar ,

     

    The ALLEXCEPT function removes all contextual filters from a table except those applied to the specified column. This is a convenient shortcut for situations where you want to remove a filter on many, but not all, columns in a table. For more details, please refer to the link: DAX ALL vs ALLEXCEPT vs ALLSELCTED | Microsoft Power BI (medium.com)

     

    If the fields in the slicer and the fields in the table visual are in the same table, then the display of data in the table will be affected by the slicer. Therefore, as Uzi2019  said, you need to create a new one that is the same as the original one. A table with no relations is used as a slicer. You can refer to this method:


    1. Create a calculation sheet.

    Table =
VALUES('financials'[Country])

    2. Use the columns in the calculated table as slicers.

     

    Alternatively, you can use the edit interactions under the format pane to set the table visual to none so that it will not be affected by the slicer.

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi klehar ,

 

The ALLEXCEPT function removes all contextual filters from a table except those applied to the specified column. This is a convenient shortcut for situations where you want to remove a filter on many, but not all, columns in a table. For more details, please refer to the link: DAX ALL vs ALLEXCEPT vs ALLSELCTED | Microsoft Power BI (medium.com)

 

If the fields in the slicer and the fields in the table visual are in the same table, then the display of data in the table will be affected by the slicer. Therefore, as Uzi2019  said, you need to create a new one that is the same as the original one. A table with no relations is used as a slicer. You can refer to this method:


1. Create a calculation sheet.

Table =
VALUES('financials'[Country])

2. Use the columns in the calculated table as slicers.

 

Alternatively, you can use the edit interactions under the format pane to set the table visual to none so that it will not be affected by the slicer.

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.