topic Re: How to avoid MONTH filter in table - in DAX Commands and Tips

How to avoid MONTH filter in table -

Anonymous — Tue, 14 Sep 2021 14:14:53 GMT

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]=SELECTEDVALUE(Sales[YEAR])))

What I am trying - I am creating a measure - FUL YEAR Budget - in which if any user selectes any month irrespective of any year - that measure must not change the value of sales - when I am clicking any month - it is filtering sales according to that month - it should be showing the total sales for selected years - whether 1 year is selected or 2 or more... Kindly help me please

Thanks and regards

RatanB

Re: How to avoid MONTH filter in table -

ERD — Tue, 14 Sep 2021 14:25:57 GMT

Hi 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.

Re: How to avoid MONTH filter in table -

Anonymous — Tue, 14 Sep 2021 14:29:54 GMT

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.

Re: How to avoid MONTH filter in table -

Anonymous — Tue, 14 Sep 2021 14:31:27 GMT

I have tried this also. but still when I am selecting months, measure is changing and showing values for months only. not for years

Re: How to avoid MONTH filter in table -

ERD — Tue, 14 Sep 2021 14:42:19 GMT

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.

Re: How to avoid MONTH filter in table -

Anonymous — Tue, 14 Sep 2021 15:16:41 GMT

no mate - it still showing the same.

Re: How to avoid MONTH filter in table -

ERD — Tue, 14 Sep 2021 16:17:16 GMT

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.

Re: How to avoid MONTH filter in table -

Anonymous — Wed, 15 Sep 2021 04:31:41 GMT

Could you please suggest me how I can upload PBIX file here?

Re: How to avoid MONTH filter in table -

Anonymous — Wed, 15 Sep 2021 04:37:20 GMT

https://drive.google.com/file/d/1SDfBBrfiwmaPCo5dQ2gNtJ2qkBNC5EwK/view?usp=sharing

Could you please try downloading file from above link?

Re: How to avoid MONTH filter in table -

Anonymous — Wed, 15 Sep 2021 06:20:05 GMT

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.