Average calculation issue with Direct Query mode

Hello,

Thanks for trying to help 🙂

I adapted the measure and ran it, I got no error but I still have 0 as a result:

I think that the problem is at the root when calculating average variable...

The strange behaviour is that I can calculate the sum (so there's data) but not the average, and count is returning (Blank) value.

Let's see if someone has an idea to share 🤞

Have a nice day