Remove filter Page from one visual only

[ilyasss]

Hello guys, 

I hope you are well.  

Before using a slicer, I was wondering if it was possible to remove a Page filter from only one visual of the page and keeping it for the other visuals ? 

Many thanks for your help, 

[mwegener]

Hi @ilyasss ,

that is currently not possible.

The filters follow a kind of inheritance hierarchy that cannot currently be interrupted. 

Unless in a DAX calculation.

Filter on all pages > Filter on this page > Filter on this visual

[ilyasss]

Thank for your responses. 

I've tried to use All to remove the page filter (month & Partially) it works partially. 

Indeed, on my report I use a month page filter. I removed the Page filter in my dax formula by using the ALL like this : 

= CALCULATE(Sales ,ALL('Date Table'[Month and Year])).

Thanks to this, the chart shows the sales for all the months for each year but I would like to filter showing only the last 6 months. I've tried this to check the logic : 

=

CALCULATE([Sales],

ALL('Date Table'[Month and Year]), FILTER('Date Table', DATESBETWEEN('Date Table'[Date],DATE(2019,11,1),TODAY())))

But it didn't work. Do you have an idea to solve this issue ? 

Many thanks for your help, 

[v-chuncz-msft]

@ilyasss 

You may also try measure below.

Measure =
CALCULATE (
    [Sales],
    ALL ( 'Date Table'[Month and Year] ),
    FILTER (
        ALL ( 'Date Table'[Date] ),
        DATEDIFF ( 'Date Table'[Date], TODAY (), MONTH ) < 6
    )
)

[ilyasss]

Hello, 

Thank for your help. 

Unfortunately, both formulas don't work properly as you can see below. The results is same for all the period and it's not the last 6 months.

I don't understand where is the issue because when I do : 

CALCULATE([% Sales],
ALL('Date Table'[Month and Year]))

I have the correct results but not in the period I I want as you can see below  : 

Do you have idea where could be the issue ? 

Many thanks for your help, 

[mwegener]

Hi @ilyasss ,

you can share the formula for 

[% Sales]

[ilyasss]

Hello @mwegener, 

The % Sales is a simple formula like X sales / Total Sales * 100. 

I tried with a simple formula like count and with the date as you see below : 

TEST = CALCULATE([Count Distinct Sales],
    ALL('Date Table'[Date]),
    DATESBETWEEN('Date Table'[Date],DATE(2019,11,1),TODAY())
)

And the result is : 

So the 389 is the total distinct sales within the datesbetween but theere is no distribution by Month. I get the impression that this issue may come from the Calculate.  What do you think ? 

To bypass the issue, I created a slicer with the date > edit interaction to delete the interaction between the slicer and the chart > Visual filter to get the data for the last 6 months. 

Nevertheless, I'm really curious to know if there is  a way to fix this with a formula.  

Thank you for your help.

[mwegener]

Hi @ilyasss ,

ALL ignores all filters regardless of where the filter (slicer) is placed.

DAX cannot differentiate between these filter levels. (Exception: ALLSELECTED)

[mwegener]

Hi @ilyasss ,

try this.

=
CALCULATE (
    [Sales],
    ALL ( 'Date Table'[Month and Year] ),
    DATESBETWEEN ( 'Date Table'[Date], DATE ( 2019, 11, 1 ), TODAY () )
)

[az38]

@ilyasss 

great question, but I do not any option like this without programming