Not affect by a single filter

[eddywong71]

Hi All,

I have create a set analysis to show the latest 30 day of record under below

sum([$<[Datee]={">=$(=max([Datee])-30)<=$(=max([.Datee]|)"),[Product]={'car'),[Month ]=>} [Total Amount])

I want the chart not affect by the Month. Because i create a filter let the user choose the month.The set analysis should affect by other filter except Month. I want the chart fixed on the latest 30 day

Can anyone help.

[rubenmarin]

Hi, there are some characters that are wrong, maybe just a typo when writing the question. also you need to ignore filters when calculating max datee:

sum([$<[Datee]={">=$(=max({<Month>}[Datee])-30)<=$(=max({<Month>}[Datee])"),[Product]={'car'},[Month]=>} [Total Amount])