Forum Discussion
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] = "...
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.
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)