Forum Discussion
J2K
6 years agoHelper I
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...
- 6 years ago
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
v-gizhi-msft
6 years agoCommunity Support