Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamically change a title based on a value.

I want to be able to dynamically change the title based on the average value within a table. I've tried the following logic Status =  if(average(RESULT)> 4,"High Performing",if(average(RESULT)> 3.5 ...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    try this

    Status = if(average('Table'[RESULT])> 4,"High Performing",if(AND(average('Table'[RESULT])> 3.5, average('Table'[RESULT])>4), "Satisfactory","Requires Review"))