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 All,
Thanks so much for your continuous help here.
The one challenge here is that the "sub-category" field comes from a parameter, which I believe may require some differences in the formula.
You'll see when I create the formula per your suggestion:
Average Score =
CALCULATE ([Score], ALLSELECTED('Field Select Parameter'))
I get the same figures as my existing column.
hi Anonymous ,
could you depict your expected result with a table?
Hi there! Can you please clarify what you mean?