Its difficult to tell without a workbook attached. My only guess is can you try aggregating the LOD calculation within the calculated field and then use it.
Thanks for your response!
I actually was able to figure it out.
I forgot to include extra filters:)
All the best,