Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Remove filter Page from one visual only

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 ?  ...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

Anonymous 

 

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
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,

     

    you can share the formula for 

    [% Sales]

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi Anonymous ,

         

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

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