Forum Discussion

heygowtam's avatar
heygowtam
Helper 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 leave]/Count[planned leave]

Count of planned leave should be 4 instead of 6

 

 

 

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

     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super 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])))