How to combine different level of filters ?

[Anonymous]

Hi everybody,

I hope this message finds you well?

I'm building a report using a date slicer (Table1). The slicer keeps only the month of January 2021.

All the visual from others tables are based on this slicer, using the following calculated measures in FILTER functions:

- Min_Slicer = CALCULATE(MIN(Table1[Date])) //01.01.2021

- Max_Slicer = CALCULATE(MAX(Table1[Date])) //31.01.2021

I'm facing the following problem:

I need to create a barchart using the Table1[Date] but it needs to ignore the slicer and to filter Date from 01.01.2020 until 31.12.2021 (filtering Date, because my Table keeps datas from 2018 to 2022).

I've tried to combine the functions ALL and FILTER but it doesn't work.

Has someone a solution to this problem?

Best regards,

Fabien

[amitchandak]

@Anonymous , Based on what I got, If you select a range and you need more than that or other than that, You need an independent date/year table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[Anonymous]

Hello,

Thank you for your answer.

So there is no DAX function that can ignore slicer's value (ignore the restriction of January 2021) and bring more datas (for example, the last 2 years)?

Best regards.

[amitchandak]

@Anonymous , if you select 2021, in slicer say for a year, then all and remove filter can show data for all year or any selected logic, but when you group it by year, it will show you only 2021, If you do want to show year on axis , you can use those logics

example

This will show last year

Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

But if use year it will still show 2021, last year value. You can not show 2020 on axis/row etc