Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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. 

Dangar332's avatar
Dangar332
Resident Rockstar
1 year ago

Hi, Anonymous 

You had used a measure as Average argument where it's only accept Column refrence not Measure, try to put score column that shown in screenshot .



 

 

Best Regards,
Dangar

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.