MEDIAN CALCULATION

[MEYERITO]

Hi everyone, 

I need some help to create a MEDIAN calculation. 

I would like to know the MEDIAN wage for a given user based on multiple comparison criteria for instance age group, job, country etc... 

To compare the user to all, quite easy, I used the "REMOVE FILTER" function in the MEDIAN calculation. 

But, when it comes to the job, I am stuck to find the right DAX.

I'd like to have the MEDIAN of the Job Category the user I selected belongs to, what would you propose to solve this? 

Thank you

[v-stephen-msft]

Hi @MEYERITO ,

You can use MEDIAN function(DAX). It can be used with the ALLEXPCET function(DAX).

If you are still confused, you can provide some dummy data and expected results to me.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@MEYERITO Try to put job category in variable and then use this variable as a filter criteria in your median calculation.