Calculate quarter without being effected by filter

Hi
im using a date table, With Quarter as an column in the table.
I like to calculate total som for each quarter in the month, but the sum should not be affected of any filters, exept of the YEAR filter (also an column in the date table).

Every transaction has a data column (related to date table).

Any idea how to do this ?

Hi @TrulsB,

Try something like this

``````Q Sales =
CALCULATE( [Total Sales],
REMOVEFILTERS( Sales ),
VALUES( Dates[Quarter & Year] )
)
``````

Hi @TrulsB, did the response provided by @Melissa help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi, thanks for Your feedback. The sum is still affected by date filters used on the same page. The filter is for every month (January, February). The filters Works well om other calculations, but in the sum for each quarter, the filter should be ignored.
I tried Your formula, but it is still affected by the calendar.
It is only one table (Sales table), and the sales date is related to the date Field in my Calendar table.
Any idea how to ignore the filters in the sum for each quarter?

Hi @TrulsB,

What do you mean by affected by the calendar?
This looks to be working properlyâ€¦

I have a filter for month name, (se pic below) With selection for each month, (i use this on other summary columns in the report), but i do now want the filter (left - each month) to affect the sum on each quarter (right sum).

The table for quarter should show each quarter sum, regardless of the filter on the left side.

Have you looked into â€śedit interactionsâ€ť
You can disable the slicer from interacting with your table visualâ€¦

1 Like

Hi @TrulsB , weâ€™ve noticed that no response has been received from you since the 15th of February. We just want to check if you still need further help with this post? In case there wonâ€™t be any activity on it in the next few days, weâ€™ll be tagging this post as Solved.

Hi @TrulsB, a response on this post has been tagged as â€śSolutionâ€ť. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

Weâ€™ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!