Disregard selection for one field and specify its value at the same time

[paweln]

Hi All,

I have a field called Date. I use it on X axis of line chart. I would like to disregard slection of that date but at the same time I want to show only values larger than 01.01.2020.

To disregard selection I konw I can use

sum({<Date=>} Measure).

To show only values larger than 01.01.2020 I use

sum({<Date={">01.01.2020"}>} Measure).

I could use

sum({1<Date={">01.01.2020"}>} Measure)

but this disregards selections for all fields. I want to disregard only Date field. How to solve that?

[durgesh22]

try this  

Dimension-->==if(date>'$(=Date(makedate(2020,01,01),'M/D/YYYY'))',date,)

Measure--> sum({<date=>}if(date>'$(=Date(makedate(2020,01,01),'M/D/YYYY'))',sales,0))