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

[UserDoe]

I got this original table:

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.

[johnbasha33]

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


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

[Rupak_bi · Accepted solution]

Hi,

Try this

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