Need help to solve median comparision

[Anonymous]

Hello All,

I have a table as above image. let say each project of different person.

i have created RLS on it. so that who ever logins to their report they can see their respective projects only at service level.

this is at powerbi desktop level.

here im trying to calculate the median of all projects, that is nothing but the global median. no filteration, nothing.

the image we have shown above is a duplicate of the actual table.

we took the duplicate of actual table and removed the rest of columns except the pro id and revenue.

now i didnt created any relation with the main table.

so that when i calculate median i can get the whole median, that is global median as per my understanding.

now in my actual main table if i calculte the median i ll get the median as per filteration of pro ids.

now i can compare this median with the global median. whether the values are high or  not.

But as i said i have created RLS in report.

so when i publish this report to service level, who ever logins to that report. then they able to see their pro id only.

that means here if a emp having only two pro id's then the global median will be shown for those two pro id's only.

But i want to get the value of global median irrespective of emp who logins to the report. means all the pro id revenue median that are there in my data.

i hope you understood my problem.

if you need any other info im happy to provide.

Please suggest me to solve this.

Thanks,

Mohan V

[CahabaData]

I am sorry but I do not understand your post.  questions to clarify:

1. Global median = 1 number only of all project data    yes/no?

2. Project median = 1 number per project ID

It was not clear if your definition of 'global median' was for 1 or 2.

Then in PBI Service, with RLS: do you want this number filtered via RLS - or - do you NOT want this number filtered by RLS ?

Your clarification will help the community give you a response.