calculate the median from an exising measure

[CJ_96601]

Good morning, 

i have an existing measure, called "Leavers" and i would like to calculate the average tenure ( field name from the same table is (YOS).

Avg Tenure = 

([Leavers]),

calculate(median('table name'([YOS])+0))

Can someone help me to fix above dax.

Thanks

Thanks

[Anonymous]

Hi @CJ_96601 ,

Can you let me know if your problem has been resolved? If yes, please share your solution in order to help more people with the same problem, if not share your sample input data (please be careful to protect private data) and expected output results.

The MEDIAN function only supports columns and not measures. If you want to get the median of a YOS column, then you can create the following measure:

Median = Median('table name'([YOS]))

If you want to get the mean of that YOS column, you can use the AVERAGE() function.

AVERAGE - DAX Guide

Best Regards,

Neeko Tang

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

[Ashish_Mathur]

Hi,

We may be able to do this with an AVERAGEX().  To receive further help, share some data, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[lbendlin]

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.

[CJ_96601]

Thanks

[Ritaf1983]

Hi @CJ_96601 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...