Average Calculation

[heygowtam]

Though the table shows 6 planned leaves by 4 people when I calculate the Average Value should consider only four names because the same person applies multiple leaves.

What I want = SUM [planned leave]/Count[planned leave]

Count of planned leave should be 4 instead of 6

 

[ryan_mayu · Accepted solution]

@heygowtam 

you can try this

Measure = sum('Table (2)'[Planned Leave])/ CALCULATE(DISTINCTCOUNT('Table (2)'[Employee Name]),FILTER('Table (2)',NOT ISBLANK('Table (2)'[Planned Leave])))