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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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!

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Anonymous - just following up on the above. If you have any insight into this it would be greatly appreciated. Thank you!