Forum Discussion
How To Calculate Average Of Averages
So this is essentially the formula I'm writing which has come the closest: Project Average Hours Per Widget = CALCULATE(AVERAGEX(SUMMARIZE(Table1,Table1[project#],Table1[WidgetOrder#]),[Hours Pe...
Basically I need that 'Hours Per Widget' number, but I then need to average them, grouped by Widget#. And I simultaneously need that average sample size to be contained within the Project#.
All of these are calculated columns that I am pulling from other tables via LOOKUPS.
Any suggestions?
It will be very difficult to assist without data. I or others here could spend an hour mocking up a model that I think matches your description, and 100% miss the boat. I've unfortunately done that one too many times.