Forum Discussion
J2K
Helper I
Helper ICounting 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
Community Champion
Community ChampionJ2K Most people use OneDrive or Box or some other file sharing service to share PBIX files.
J2KHelper I
Helper IGreg_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.
- v-gizhi-msft
Community Support
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
- J2K
Hi Giotto,
Thank you very much. This works perfectly.