Exclude a card from any existing filters without cancelling them

[Anonymous]

Hello everyone, 

I would like to know if there is any exisiting way of excluding a card from any existing filters.

Let me explain : In order for my numbers to fall right, I need to set a filter for the whole report/page excluding a category called "Other", but for a specific calculation, the "Other" category needs to be taken in account to get the right result.

Do you know any trick to avoid setting filter on each visualisation except the calculation I need ? 

Thank you for your help,

Alexandre

[Cmcmahan · Accepted solution]

Sure. There are a few ways to do this. 

1) You could edit the slicer interactions. This way, slicers just don't apply.  Unfortunately, it sounds like you have a page level filter, so you're more likely to have luck with #2.

2) You could change the calculation to specifically ignore filters.   I don't know what your calculation is, but the general form would be something like this:

CardCalculation = CALCULATE( [MyCalculation], ALL('Data'[Category]))

This ignores all filters on the column [Category].  

Without knowing the measure you're using for the card, I can't be any more specific than this.  Hopefully it's helpful.

[Anonymous]

I have a page filter yes, solution #2 worked perfectly thought, thanks a lot for your quick answer