I came across this knowledge base article that stated that
I think you will need to use WINDOW_PERCENTILE instead of PERCENTILE
I'm not sure if it is similar to your workbook, but I tried it with the SuperStore sample and it
seemed to work using
IF SUM([Sales]) >
Please see workbook v10.3 attached in the Forum Thread.
278479upperhinge.twbx 1.2 MB
Thank you for your help!
Indeed, WINDOW_PERCENTILE function is useful when you may have to change the data context (the dimensions). However, I also needed to get the same results but in a different view level, that is why after researches, it is necessary to use LOD (Level Of Detail) functions.