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. 

FreemanZ's avatar
FreemanZ
Super User
1 year ago

hi Anonymous ,

 

try like:

average =

AVERAGEX(

    VALUES(data[sub category]),

    [KO Profitability Score]

)

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.