Forum Discussion

Helper III

3 years ago

Calculate Median Value

Hello, I have the below raw data where i have First Pass Orders and Total Orders, I had a measure to calcuate Customer wise First Pass %, which is sum of First pass orders / Total Orders. Then...

Community Champion

3 years ago

Hi shantupm5 check for blanks,

MEDIANX does not ignore blanks; however, MEDIAN does ignore blanks

https://learn.microsoft.com/en-us/dax/medianx-function-dax

I hope this help in explaining difference in results

Forum Discussion

Calculate Median Value

Related content

Help with Median

Calculate median of a measure and a calculated column based on median

DAX for calculating retroactive values

median of calculated median

Calculate median