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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Neeko,

     

    Please find a sample file here. 

     

    Please let me know if you have any troubles with access.

     

    Thanks!

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      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. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        This worked! Thank you so much everyone for all of the assistance!