cancel
Showing results for 
Search instead for 
Did you mean: 
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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.