Forum Discussion
Helper IMatrix visual with calculated columns : add an average column of the shown columns?
Hi volt26
Sure, you can try this:
MEASURE = VAR _vtable = SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[ID], 'Table'[Num], "_AVG", [AVG] ) RETURN AVERAGEX ( _vtable, [_AVG] )The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IWow! What you did is fantastic!
I'll push my luck and ask an extra question but if this should be in another thread simply tell me I will do so. I'm aware that you probably want me to click the accept as solution button by now! 🙂
So...
Now that I have the AVG for each selected cycle, is it possible to have a column that will show the average of the averages? Like this :
(sum of all selected Num columns)/(amount of Num columns selected) = Average of averages
(4+7+1+8.67+9)/5=5.934
Hi volt26
Sure, you can try this:
MEASURE =
VAR _vtable =
SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[ID], 'Table'[Num], "_AVG", [AVG] )
RETURN
AVERAGEX ( _vtable, [_AVG] )
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- volt26
Thank you very much for your help!