Forum Discussion
Avg Total
Anonymous
If the total average isn't correct, it probably has to do with the filter context of the table/matrix and how the relationships are established in the model, and/or the measures involved.
So we need more information about the model, how the table/matrix is set up and any measures involved.
(You will probably solve this by using an AVERAGEX(SUMMARIZE...) but it may be overkill depending on the model structure and matrix filter context)
Anonymous
It appears you are using AVERAGEX with a column as the expression. If you are averaging a column in a table, Just use the function AVERAGE.
otherwise, create an aggregation measure for the column values (like SUM) and use that in the AVERAGEX function. Something along the lines of :
AVERAGEX(Table, [Sum of values])
Hi Paul - I tried your formula, and several others with and without AverageX.
For the love of God I just want a simple average of the column! 😁 There are 32 records in this list. 4000 / 32 = 125 (but that is not the value I want to show). So I can see what Power Bi is doing....it's jut not what I need it to do.
I want to show the same value as what Excel shows....or what it will show if you just were to add up Avg Opp Age and divide by 6...which will be 108.66.....not 125.