ignore Filter with 1

[Samanehsorournejad]

Hi every One,

I had try to ignore the Filter effect in my measure but I could not understand why it Still change, although I had use 1 .

Measure is :

sum({1 <OrderDate={"$(=Date#(Date(Max(OrderDate)-1),'DD.MM.YYYY'))"}>}Sales)

just for info: I try to calculate the sales of one day before last day , the measure works truly but it change when I choose an other filter such as Customer, OrderDate and so

Is there any Idea why it still change🤔😐

[Or · Accepted solution]

Max(OrderDate) is presumably still being evaluated within the context of your selections. Perhaps Max(ALL OrderDate) instead?

[Samanehsorournejad]

Hi,

yes, your write, now it does not change. Could you please tell me when should I use 1 and when should I use ALL?

Since now I did not hear any thing about [ALL], could you please give me the tutorial?

Thanks a lot

Samaneh

[Or]

There's no difference between ALL and {1}, I believe. I find it cleaner not to put set analysis inside another set analysis unless I have to, so I prefer to use ALL in this case, but they achieve the same thing.