Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Rodwki
Frequent Visitor

AllExcept Problem, showing right results in table

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 : 

Rodwki_1-1657383817765.png

 

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?

1 ACCEPTED SOLUTION

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Where is the file?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

On this page : https://goodly.co.in/calculate-percentile-in-power-bi/

At the bottom of the page : 

Rodwki_0-1657438882081.png

 

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.