Forum Discussion

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

Average Calculation Problem

I have two columns for employees and their leave details 1) If I Calculate the planned Average,  Because of the Same name it calculates as 1 instead of 2  for example - Employee [Stace] has two...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Share some data to work with and show the expected result.

MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
4 years ago

Hi,

if you want to calculate the average of the planned value for each employee (exclude the null value) use the below code in your measure :

DIVIDE( sum(Sheet234[planned]), COUNT(Sheet234[planned]))
If you want to include the null value per each employee : 
DIVIDE( sum(Sheet234[planned]), CALCULATE(COUNTROWS(sheet234), Sheet234[Employe] = SELECTEDVALUE(Sheet234[Employe])), 0)
This is the sample data :

Appreciate your kudos and please mark it as solution if it helps

heygowtam's avatar
heygowtam
Icon for Helper II rankHelper II
4 years ago

Hi, Thanks for the reply The value seems the Same even after trying both options.