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