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