Nan Error

[Anonymous]

Jolly Day,

Newer to power BI and am getting a NaN error with the below formula. I need to add an if statement I believe but am not sure how to implement it. Could I get some help with this?

S Daily Average = CALCULATE(Audit[SUM prozacs]/MAX('Working Days'[Working Days]) + 0)

Many thanks,

Lydia

[Anonymous]

This worked! Thank you much!! 🙂

[HotChilli · Accepted solution]

You use the DIVIDE function in this case:

https://learn.microsoft.com/en-us/dax/best-practices/dax-divide-function-operator