Showing a measure withut date filters already applied

[Anonymous]

I have a Sales amount column in my table. My table is connected to a dim_table on a date field.

on one side of the report I have metrics for a particular month and there is a slicer with a month selection there.

On the right, I want to show the sales figures for all months on a graph. I created a metric, which should show me sales value, but when I plot it across months I just get one month, like on screenshot below, and the amount I don't know where this is coming from - strange sum of don't know what.

I also tried with ALL() instead of remove FIlters, but getting the same result

How can I fix it?

Turnover Over all Months =

CALCULATE(

    SUM(source[SaleValueNet]),

    REMOVEFILTERS(dim_date[Year_Month]))

Also tried removing both quarter and month filters, but then whne i plot it over months I get whole year filter for each month:

Turnover Over all Months =

CALCULATE(

    SUM(source[SaleValueNet]),

    REMOVEFILTERS(dim_date[Year_Month], dim_date[QuarterWithYear]))

[dharmendars007]

Hello @Anonymous , 

Use "ALL" on the correct date hierarchy: If you want to remove only the month filter but keep the year or other time context, you should be careful about which parts of the hierarchy you're unfiltering.

Please try the below code...

Turnover Over all Months =
CALCULATE(
SUM(Source[SaleValueNet]),
REMOVEFILTERS(dim_date[Year Month]),

VALUES(dim_date[Year]) -- Keep the Year context, but remove the month context)

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN