Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate Mean based on 1 column

Hi PBI Professionals. I'm having a difficult time trying to get the Mean value based on 1 column. below is what I currently have: Day Cellname Cell1 Total days Mean cell1 25 ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

Based on my test, you could refer to the deldersveld function and I have tested, it could work:

Also, you could use the measure to get the result:

Measure = AVERAGEX(ALL(Table1),'Table1'[Cell1])

Hope it could help you.

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-danhe-msft, deldersveld,

Sorry I think I didnt give you the full information.

 

 

 

 

 

 

 

 

 

 

 

To attain Cell Count the following calculated column was created: 

Sum Count = SUM('Sheet Append'[Cell Count])

however when I use a slicer user name it doesn change the sum count value. 

 

 

 

 

 

 

 

 

 

 

 

If i can get this column to reflect the changes of the slicer then i would think it would be easy to get the mean out

 

 

My original data sheet looks like this:

 

 

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    I suggest you try to use measure to calculate the sum of [Cell count] instead of a calculated column, due to the calculated column is evaluated for each row in your table, immediately after you hit 'Enter' to complete the formula and will be saved back into the model as a fixed value, you could refer to this blog:

    https://projectbotticelli.com/knowledge/dax-calculated-columns-vs-measures-video-tutorial

     

     

    Regards,

    Daniel He