About the median value

Questions & Answers
1

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

2

Hi,

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:

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

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