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"))

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
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"))

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mwegener , thank you worked straight away! Got to love the PBI community, to get a fix within 3 minutes!!