Forum Discussion

xuxxay88's avatar
xuxxay88
Icon for Helper I rankHelper I
3 years ago

2019 Constant Line with 2019 Excluded From Chart

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,

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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) )