Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |