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

supriyad's avatar
supriyad
Frequent Visitor
8 years ago

quentin_vigne Currently I calculated Expected mean values manually to show you..

But I am expecteing My measure should give me values like this..

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