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 Anonymous ,

 

Thanks to Dangar332  and FreemanZ  for their quick replies. I have some other thoughts to add:

Based on your description, the Score you are displaying on the visual object is the measure, correct? If I have misunderstood you please clarify in a follow up reply.
Then we can create a new measure.

Avg = CALCULATE([Score],ALLSELECTED('Table'))

Then the result is as follows.

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 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.

 

 
  • FreemanZ's avatar
    FreemanZ
    Super User
    1 year ago

    hi Anonymous ,

     

    could you depict your expected result with a table?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi there! Can you please clarify what you mean?