2019 Constant Line with 2019 Excluded From Chart

[xuxxay88]

Hi,

My fact table consists of Year, Retailer ID, Total Sales. The Year is not linked to the calendar table year.

In the chart, I want to display the sales values for 2020 - 2022 and use a constant line for 2019 values.

I have a filter on the visual to include where year > 2019 which is preventing me from using CALCULATE([Total Sales], Fact[Year]=2019).

The problem I have is if I use REMOVEFILTERS() I then lose any filtering that is being applied on the RetailerID.

Thanks,

[amitchandak]

@xuxxay88 , If these are no filters on the date the above measure should work

CALCULATE([Total Sales], filter(all(Fact[Year]), Fact[Year]=2019) )

In this case, I think you need a slicer on an independent date table

then this will work

CALCULATE([Total Sales], filter(=(Fact[Year]), Fact[Year]=2019) )