Calculate median and average in a partition in Tableau using table calculation

Question

I am having a table rows such as postID and subjectIS as primary key in the table,some has subject level and post level measures

+---------+-------------+--------------+------------+--------------+--------+
    | post.ID | post.Author | post.Replies | subject.ID | subject.Rank | year   |
    +---------+-------------+--------------+------------+--------------+--------+
    |   1     |   mike      |     10       |    movie   |     4        |  1990  |
    |   1     |   mike      |     10       |    comics  |     6        |  1990  |
    |   2     |   sarah     |      0       |    tv      |    10        |  2001  |
    |   3     |   tom       |      4       |    tv      |    10        |  2003  |
    |   3     |   tom       |      4       |    comics  |     6        |  2003  |
    |   4     |   mike      |      1       |    movie   |     4        |  2008  |
    +---------+-------------+--------------+------------+--------------+--------+

Putting measures like COUNTD(post.ID) and COUNTD(subject.ID) in rows and 'year' in column

And i want to drag MEDIAN(subject.Rank) in Color,and I am not getting a proper result

How can I improve it 

Answer 1

We can try by using the formula

{fixed [1st LEVEL],[2nd level]: median()}

 If you want to learn more about it Tableau, then go through this Tableau Training for more insights.