Forum Discussion
LotteLaugesen
Helper V
Helper VAverage 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
- AlB
Community Champion
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
LotteLaugesenIt's because I'm a newbie to both Power BI and DAX 😊
But thanks alot it works 😀