Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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🤔😐
Max(OrderDate) is presumably still being evaluated within the context of your selections. Perhaps Max(ALL OrderDate) instead?
Max(OrderDate) is presumably still being evaluated within the context of your selections. Perhaps Max(ALL OrderDate) instead?
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
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.