Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PBI Formula

Need help understand the DAX formula. I need to replicate this in tableau.

 

_session avg times =
var result = CALCULATE(AVERAGE(Invoices[Billed Hours]),FILTER(Invoices, Invoices[Appt Outcome] = "completed" || Invoices[Appt Outcome] = "consultation" || Invoices[Appt Outcome] = "intake completed" || Invoices[Appt Outcome] = "treatment navigation")
)
return
IF(ISBLANK(result),0,result)


General Comment
Need Help

2 Replies

  • Syk's avatar
    Syk
    Resident Rockstar
    3 years ago

    It is averaging the 'Billed Hours'
    where 'Appt Outcome' = "completed" OR "consultation" OR "intake completed" OR "treament navigation"
    The return is just handling Power BI's default of saying "(Blank)" if there is no data. All the return is saying is if it is blank, give me 0, if not, return the average that was just comptued.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Syk 

      Thank you for your response.

      So when i convert it into tableau
      AVG(IF [Appt Outcome] IN ("completed","consultation","intake completed","treatment navigation") THEN [Billed Hours] END)