Forum Discussion

heygowtam's avatar
heygowtam
Icon for Helper II rankHelper II
3 years ago
Solved

Average 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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    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])))

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

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])))