Ignore date in measure and visual

[Rocon]

Hi,

I'm struggeling with a measure and have tried so many different ways but don't get it to work. To simplify the problem, let's say I have two data tables and have created a measure that calculates data from the two tables. These are related to a Calendar table. IN my report I have several measures and a date slicer with interval and I only want some of the visual shall respect the date filter. For this measure I'm struggeling with is that I want the measure to ignore the date range selected and show the value per month in my visual. I've tried removefilter but don't get it to work as I want. 

To summarize: I want a filter to ignore date range selection and show me the value for each month for the year.

Many thanks!

[Rocon]

Thank you so much! I thought I tried this and many other solution but started from scratch with a simple test of this and it worked great.

Thank you again and so appriciated!

[SamWiseOwl · Accepted solution]

Hi @Rocon 

You can specifiy the Date field filter to be remove and the month filter will stay.

Here I have Sale[Date] as a slicer byt Sale[Date].Month as the field.

In the Calculate removing the Sale[Date] filter doesnt affect the Sale[Date].Month filter.