Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this kpi . CurYTDFlag is a master calendar field based on a field called "Date".
count({1<CurYTDFlag={1},[Order Status] = {'1','2'},
[ordernum] = {"=Len([ordernum]) = 10"}>} distinct [order ID])
which will not become static whenever I choose a random date from my "Date" filter pane.
Thing is, when it's simply
count({1<CurYTDFlag={1}>} distinct [order ID])
it works perfectly.
What is wrong?
Try this:
count({1<CurYTDFlag={1},[Order Status] = {'1','2'},
[ordernum] = {"=Len(only({1}[ordernum])) = 10"}>} distinct [order ID])
Try this:
count({1<CurYTDFlag={1},[Order Status] = {'1','2'},
[ordernum] = {"=Len(only({1}[ordernum])) = 10"}>} distinct [order ID])
Hello, thanks for the quick response,
tried it but still not static 😞
Edited: *** actually, no, it worked perfectly! Could've never figured out... Thanks 🙂
What does this addition do?
@tresesco hello, hope you're well 🙂
I need your help once more for this cytd-lytd. I have the same problem, I want it to not change when i pick a date from the date filter. How to use only{1} here? Or is there another way?
fabs(sum({1}{< curYTDFlag={1},[year]=, [month]= >} [measure])
-Sum({1}{<[Date]={">=$(=YearStart(Max(date([Date),'DD/MM/YYYY'),-1))<=$(=AddYears(Max(date([Date]),'DD/MM/YYYY'),-1))"},[year]=, [month]= >}[measure])
)