Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have a problem with function ALLEXCEPT. So, I calculate the percentiles in my work and my work is based on this link : https://goodly.co.in/calculate-percentile-in-power-bi/
(At the bottom of the page you can download the file)
I know more or less, how the ALLEXCEPT function work, but I don't know how I can work around my problem. I modify the file in the link :
So, I would like the same result as in the left table to appear on the right table (red color), I know that when I add the column "Occupation" to the right table then I see the correct results, but that's not my aim. I want occupation percentile without showing the Occupation column. How should I modify the measures?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Where is the file?
Hi,
You may download my PBI file from here.
Hope this helps.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
94 | |
83 | |
32 | |
27 |