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 ...
You can't use variables the way you do. Variables in DAX are in fact static. Once calculated, they never change, so your attempt to use a variable in the function the way you try to is futile.
Ultimately, all I am trying to do is have the corresponding percentile for each row by country and then by city. I am just trying things out and suggesting ideas to get there.
I would like to avoid calculated columns because to my understanding they are more ressource intensive (the column would be on a large table) especially since I have to make a dozen of percentil measure with data on the same table (I have a dozen categories)