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

 

What is the formula that you used for you expected mean? (Like what is the calculation you need me to translate to dax)

 

- 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