Forum Discussion
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...
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
Suppose Project 1 having score 3 then mean should 3/11 i.e total count of projects according to Month Year.
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