It's expected. The Average() function in a calculated column returns the average (arithmetic mean) of all the numbers in a column. In your original post, you are trying to display average value in a card visual, the measure provided in my previous post can works.
Best Regards, Qiuyun Yu
Community Support Team _ Qiuyun Yu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.