Ignore date in measure and visual

Question

Hi,&nbsp;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.&nbsp;To summarize: I want a filter to ignore date range selection and show me the value for each month for the year.&nbsp;Many thanks!&nbsp;

samwiseowl · Accepted Answer

Hi&nbsp;Rocon&nbsp;&nbsp;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.&nbsp;&nbsp;

Forum Discussion

Ignore date in measure and visual

2 Replies

Related content

Ignore filter for a measure

Make measure ignore specific filter

Ignore visual level filter from a measure

Ignore Slicer in measure

Measure to ignore filter from clickable visuals