Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
I have a page filter yes, solution #2 worked perfectly thought, thanks a lot for your quick answer
User | Count |
---|---|
128 | |
112 | |
99 | |
65 | |
62 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |