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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
UserDoe
Regular Visitor

How to calculate median for grouped data without making new table?

I got this original table:

 

UserDoe_0-1712659724855.png

 

 

I need to calculate median values for selling_eur.

How can I do it?

I got only some ideas.

Transform table with duplicated rows for calculation. It will not work fast.

Some how add new column, thich contains arrays with duplicated prices for calculation. I got no idea how to add it.

1 ACCEPTED SOLUTION
Rupak_bi
Super User
Super User

Hi,

 

Try this

calculate(Median(table,selling_eur),allexcept(table,category))



Regards
Rupak
FOLLOW ME : https://www.linkedin.com/in/rupaksar/

View solution in original post

2 REPLIES 2
johnbasha33
Super User
Super User

@UserDoe 
Median Selling EUR =
MEDIAN('YourTableName'[selling_eur])


Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Rupak_bi
Super User
Super User

Hi,

 

Try this

calculate(Median(table,selling_eur),allexcept(table,category))



Regards
Rupak
FOLLOW ME : https://www.linkedin.com/in/rupaksar/

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.