topic ignore Filter with 1 in App Development

ignore Filter with 1

Samanehsorournejad — Sat, 02 Apr 2022 18:42:21 GMT

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🤔😐

Re: ignore Filter with 1

Or — Sun, 03 Apr 2022 13:27:30 GMT

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

Re: ignore Filter with 1

Samanehsorournejad — Mon, 04 Apr 2022 07:50:04 GMT

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

Re: ignore Filter with 1

Or — Mon, 04 Apr 2022 08:00:02 GMT

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.