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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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