DAX REMOVEFILTERS() Issues

[amconnel]

Hello,

I am attempting to use the REMOVEFILTERS() function to ignore a slicer slection in a measure. My goal is to show one day with Projections for 2023, have a second table that will show data from 2022 (depending on a slicer selection for "Version" either "AOP' or "Prior Year"), and a third table to show the variance between the two. This variance calculation needs to ignore the slicer selection so that it can pick of the Projections for 2023 values, but then determine which values from 2022 ("AOP" or "Prior Year") to pick up based on the slicer selection for "Version" and calculate the difference of the two values. See the screenshot below for my current state and a screenshot of my test data.

 

Purple box: Projected 2023 data

Orange box: 2022 data, determined by "Version" slicer at the top = "Prior Year" for this example

Yellow box: Using the current DAX formula that is incorrect (DAX shown below). If you look at the data, it is summing the 2022 "AOP" and "Prior Year" data for the Periods ending in 2022, but it is still filtering out the 2023 Projection data. Ideally, this should show 6 periods to include all data, completely ignoring the Version slicer without editing the interactions between the two visuals. 

Value Unfiltered = 
CALCULATE(SUM('Test Variance'[Value]), REMOVEFILTERS('Test Variance'[Version]))

 I believe this has something to do with auto-exist, but I cannot make sense of this linked article. Any help solving this is greatly appreciated! Thanks!!

[v-yueyunzh-msft]

Hi,  @amconnel 

 According to your description , for the third visual you want to ignore the filtering of the slicers. Right?

All you have to do is select the slicer, click "Edit interactions" in the "Format", and close the slicer you don't want to filter,like this:

Best Regards,

Aniya Zhang

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

[amconnel]

I have a greater issue past what this original post is about and editing the interactions is not an option. I still need the visual to interact with the slicer for one aspect of a measure I am attempting to create but ignore the slicer for another aspect.

[johnt75]

If it is caused by auto-exist the simplest way to fix it is to move either the attribute or the version column into a separate dimension table and then use the column from the new table in all visuals and slicers.

The simplest way to create a dimension table is 

Dim table = ALLNOBLANKROW('Fact table'[Column])

then create a one-to-many single direction relationship from the dimension to the fact table.