Question about displaying previous year data over current year data

QuantamPulse Maybe try ALLEXCEPT

Hi QuantamPulse 

Certainly, you can understand it as:

The columns from the specified table for which you want to keep filters. Filters on all other columns will be removed.

The primary use case of ALLEXCEPT is to create calculations within a particular context while disregarding filters applied to other columns. This is especially handy in scenarios where you need to perform calculations within a specific dimension or attribute of your data, ignoring filters on other dimensions.

Here is a blog about the understanding of context:

Understand the Filter Context and How to Control i... - Microsoft Fabric Community

Links of ALLEXCEPT():

Demystifying the ALLEXCEPT Function in DAX | by Andrew Hubbard | Microsoft Power BI | Medium

The Power BI ALLEXCEPT function (datascientest.com)

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.