Forum Discussion
How to avoid MONTH filter in table -
Hi Team Below is the snapshot of my data And below is the table I have genrated in PowerBI Full Year Sales = CALCULATE(SUM(Sales[SALES]), FILTER(Sales,Sales[YEAR]=SELECTED...
- 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.
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
Community Champion
Community Champion- 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.
Could you please suggest me how I can upload PBIX file here?