Forum Discussion
Solved
Average in Grandtotal
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 😀
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
2 Replies
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
It's because I'm a newbie to both Power BI and DAX 😊
But thanks alot it works 😀
