Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure to return value based on another measure

Hi all, new to the group and PBI, this will be basic for a lot of you, I have a measure - "Hourly Average = DIVIDE([Inducted],[Hour Runtime],0)". I want this to return a the value only if another mea...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi Anonymous 

     

    Try this

     

    Hourly Average = IF(Sorted > 50, DIVIDE([Inducted],[Hour Runtime],0), "")

     

    regards

     

    Phil

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thankyou!