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.

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi klehar 
Yeah . It is showing 66 as correct answer as per your ALL filter. 

What exactly do you want to show on table. can share screenshot of expected output through excel or something??

 

If you dont want your table should be filtered based on your selection just simply disable the edit interaction option.

 

If this is not what you are looking for share the expected result.

 

  • klehar's avatar
    klehar
    Helper V
    2 years ago

    Ic ant turn of edit interactions in my context. This is just sample data of my real project.

    All I want is all Geo data to be present (it should not be filtered) even if a geo filter is used as a slicer

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      Hi klehar 

      You can create a seperate table with slicer value (Geo) in it. make sure there is no relationship between them.

      If you create relationship then it will filter your Geo data

       

      I hope I answered your question!

       

      • klehar's avatar
        klehar
        Helper V
        2 years ago

        Is there no way using DAX that a context can be changed?

        I thought ALLEXCEPT could work in this situation