Forum Discussion
Trouble Calculating a Dynamic Average
Hi All, I am trying to add a new measure that dynamically calculates the average of all the values based on the parameter selection and I am getting an error saying "parameter is not the correct ...
Hi Anonymous ,
Create this measure.
Average Score = CALCULATE ([Score], ALLSELECTED('OST'))Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi there,
Thank you so much for the help on this. It appears that while that solution worked for that particular instance, I am having trouble applying correctly to another instance. As you see in the screenshot, the "total" is showing as 19, however, that is incorrect as the average should be closer to 9. Do you have any idea why this might be?
Appreciate any assistance here in advance. Thank you so much!
Hi Anonymous - just following up on the above. If you have any insight into this it would be greatly appreciated. Thank you!