Forum Discussion
Filtering with Percentile.INC
Who says 9000 measures? You clearly don't understand how the measures I wrote work. You only need 3 measures for the whole setup to do what you want... Jesus... :(
My advice is to learn something about DAX and Power BI.
Best
Darek
I'm trying to....
I understand you showed three measures and said that it would work for any filters. The problem I am trying to solve has 85 units and there are 36 contaminants per unit. I need to be able to filter through all the units individually and find the percentiles associated with each contaminent (score). I have 85 units each with 36 contaminants and I need 3 percentiles for each so 85*36*3 is just under 9,000.
Maybe you could explain the measure a little more to me then and that could be what I am looking for?
You can put all your units on the row axis of a matrix, then all the contaminants on the column axis and then drop the measures onto the matrix. It'll display the percentiles for any combination of ( unit X contaminant ).
What's the problem here? I can't see any... The matrix can be filtered for particular units and contaminants with slicers as well to limit the data to display.
Best
Darek
I need to still run calculations with those numbers. They are not my final values to put in a matrix and display with slicers. They are an intermediate step to get to the final value where I will put everything in a matrix to display.
What's the problem again? Once the measures work for ANY selections, you are free to use them in other calculations... I have already given you a piece of good advice: Please TRY TO LEARN SOMETHING ABOUT DAX AND POWER BI before you start using them for real work. There are many good books and websites about it. Just use Google to find them.
Your problems stem from the fact you know next to nothing of the tool that you're supposed to use. THAT'S PRETTY BAD. It's like telling somebody who knows (almost) no maths at all to use it to calculate something.
When I do something, I first try to learn the capabilities of the tool I'll be using. Is this not obvious? That should go without saying.
At this point I can tell you that you have all you need to do further calculations.
Best
Darek