Forum Discussion
How to avoid MONTH filter in table -
- Full Year Sales =CALCULATE(SUM(Sales[SALES]),REMOVEFILTERS(Sales[MONTH]))Above was the solution I tried and it worked like charm. Thanks for your help.
Community ChampionHi Anonymous ,
Just choose this particular slicer not to filter your table:
- click on the slicer
- choose Format tab
- click Edit iteractions
- hover over the table
- choose None option
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
Hi Thanks for you reply.. But problem is I have other visuals also on which I dont want this to be impacted, thats why I am looking where a mesaure could be created which would not have any impact incase any month filter is selected.
- ERD
- You can edit iteraction for each visual
- In case of a measure, you can use ,ALL(T[MONTH]) modifier in your CALCULATE
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
no mate - it still showing the same.
- ERD
The thing I'd suggest in this case is to upload a .pbix sample so that me or someone else can check.
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.