Forum Discussion
Solved
Counting Zero-Value Measure Rows in Median Calculations
I need the median value of a column (whose value is derived from a measure). In every attempt, it is only returning the median of rows that have a value greater than zero. I have two tables, one...
Hi,
Please try this measure:
MED Col A = MEDIANX(SUMMARIZE(Employee_M,Employee_M[Employee ID],"EE",[EE Attend]),[EE])The result shows:
See my attached pbix file.
Best Regards,
Giotto
Greg_Deckler Here you go:
https://www.dropbox.com/sh/e9nhfa9ct8lvgdt/AABA4QgxXplpOARmOqiK4qlpa?dl=0&preview=MedianDemo.pbix
Again, I appreciate that you take the time to look at these things.
Hi,
Please try this measure:
MED Col A = MEDIANX(SUMMARIZE(Employee_M,Employee_M[Employee ID],"EE",[EE Attend]),[EE])The result shows:
See my attached pbix file.
Best Regards,
Giotto
Hi Giotto,
Thank you very much. This works perfectly.