median of calculated median

[blazko]

Hi, 

So I have this problem, I have a table with individual efficiency scores (per day) of each worker. I know how tu calculate a monthly median for each one of them. But, each worker is assigned to a different sector. And what I want to do, is to calculate a monthly median, from a monthly median (score) from every worker assigned to a spesific room (chose by a slicer or filter). So a monthly median for each sector, but calculated from monthly scores of workers assigned to it.

What i have:

- a table with date (daily), worker id, and score 

- a table with workers id's, and sector

Tried various combinations and nothin, either empty result or dax error. Im new to it so the struggle is big. Please help.