Forum Discussion
Filtering with Percentile.INC
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