l

Thanks parry2k,

I think this might help some. But my main question is if it is possible to calculate this average of a measure that is set to only calculate the efficiency for yesterday's values, which is done using TODAY()-1. I recently tried using a calulated column but the value was not as accurate as I would like.