heygowtamHelper II3 years agoSolvedAverage Calculation 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 l...Show Moreryan_mayu3 years agoheygowtam 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]))) 1.PNG5 KB
ryan_mayu3 years agoheygowtam 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]))) 1.PNG5 KB
ryan_mayu3 years agoheygowtam 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]))) 1.PNG5 KB
ryan_mayuSuper User3 years agoheygowtam 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]))) 1.PNG5 KB
Related contentCalculating Weighted AverageDAX Measure for Ranking the valid rows and calculating the average ratingCalculating average 12 month averageAverage CalculationAverage calculation
