Average in Grandtotal

[LotteLaugesen]

Hi

I have found out how to calculate average in subtotal 😀 , but how do I do the same in grand total?

I'm getting a sum instead of average....

Please help 😀

[AlB · Accepted solution]

Hi @LotteLaugesen 

Why don't you use AVERAGEX instead of SUMX?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[LotteLaugesen]

It's because I'm a newbie to both Power BI and DAX 😊

But thanks alot it works 😀