Changing context

[klehar]

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?

[Anonymous · Accepted solution]

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]

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]

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]

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]

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

I thought ALLEXCEPT could work in this situation