About the median value

I want to calculate the median value, how to write this formula,thank you!


To calculate the median value of all children of the expanded group-member (All Developers) you could try using the “Median” function with “Descendants”.

Please try the following example:

Descendants([Developer].CurrentMember, [Developer].[Developer]),
[Measures].[Tasks] > 0

Note that this example is built assuming that the name for your dimension and level is “Developer”.

Please reach out to support@eazybi.com if you have further questions about this example!

Kind regards,
Martins / eazyBI support