Forum Discussion
Add percentiles using a calculated measure
Hello everyone, first time posting, I will do my best to make this post right : I am stuck right now on a rather complex report I was asked to maintain and update. The way the data model ...
What I am trying to do is to have in which percentile all those cities are. For example, if they are in the top 90% it would be 0.9.
Are you trying to create a measure or a calculated column? It's not obvious. By the way, you cannot write a measure that would return just one number for a set of cities to inform you in what percentile they all are. This question is ill-posed. You should really think hard about what it is you want to do and then carefully describe it here.