Forum Discussion

supriyad's avatar
supriyad
Frequent Visitor
8 years ago
Solved

Calculate Mean using Measure

Hi all, I want to calculate the mean for following values shows in picture. I am filtering data Using Program Manager Name.      I used following measure to calculate mean :   Mean = CAL...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    supriyad

     

    I see now.

     

    What you want is this : 

    Mean2 = DIVIDE('Project Rank'[Score];CALCULATE(COUNT('Project Rank'[Score]);ALL('Project Rank')))

     

    (Isn't your mean supposed to be more something like 'Score / Total of score' ? It just seems strange that you divide the score by the count of your table ... Maybe it's just me and I'm stupid today ahah)

     

    If it worked, don't forget to mark your topic as solved

     

    - Quentin

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

supriyad

 

Yes but how did you calculated them manually ? 

 

- Quentin

supriyad's avatar
supriyad
Frequent Visitor
8 years ago

quentin_vigne

 

Suppose Project 1 having score 3 then mean should 3/11 i.e total count of projects according to Month Year.

  • quentin_vigne's avatar
    quentin_vigne
    Solution Sage
    8 years ago

    supriyad

     

    I see now.

     

    What you want is this : 

    Mean2 = DIVIDE('Project Rank'[Score];CALCULATE(COUNT('Project Rank'[Score]);ALL('Project Rank')))

     

    (Isn't your mean supposed to be more something like 'Score / Total of score' ? It just seems strange that you divide the score by the count of your table ... Maybe it's just me and I'm stupid today ahah)

     

    If it worked, don't forget to mark your topic as solved

     

    - Quentin