Forum Discussion

gregomex's avatar
gregomex
New Member
3 years ago

Delete explicit filter and apply new filter (date)

Hello everyone,   I have a model made up of a table of dates starting in 2020. It's associated with a fact table from which I've created measures (e.g. sales sums). The visualization I'm using con...
Need Help
Tutorial Requests
Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
3 years ago

Hi gregomex ,

You can try something like this

Salessince2021 = CALCULATE(Sales, FILTER('Table', 'Table'[Date] > DATE(2021,01,01)))

 

Regards,

  • gregomex's avatar
    gregomex
    New Member
    3 years ago

    Thank you Thejeswar.

    However, Explicit filters (Slicers) do affect the calculation. So, applying filters as of June 2023 only give me results of this month, whereas I need Sales since 2021, whatever the slicers filters are. Thanks

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

      gregomex ,

      You can switch of the interaction between the Slicer and the Particular visual where you are using this meason and want to see data starting 2021.

      This can be done using the Edit Interaction option.

      Please go through the below link that gives info about Edit Interaction option and how you can use it

      Change how visuals interact in a report - Power BI | Microsoft Learn

       

      Regards,