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

 

Thanks so much for getting back to me. So when I update per your suggestion above I just get the same values, not the '17' value I was expecting. The first column is based on a parameter and changes between category and sub-category. 

 

Average KO Profitability Score = averagex (VALUES('Field Select Parameter'[Selection Parameter Fields]),
[KO Profitability Score])
 

 

 

Dangar332's avatar
Dangar332
Resident Rockstar
1 year ago

Hi, Anonymous 

Try below amended measure 

Average KO Profitability Score = 
averagex (
 allselected(
      'Field Select Parameter'[Selection Parameter Fields]),
       [KO Profitability Score]
)

 

Best Regards,
Dangar

 

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

     

    Thanks so much for your help. The solution is now showing up like this (it should show up as all 17s) using the above formula.