PBI Formula

[Anonymous]

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)

[Syk]

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]

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