Forum Discussion
Average Formula
How can I build a DAX formula that will return the average of the highlighted column. I'm trying to do this to get the average by year & quarter:
Anonymous
Both measures are in the middle. Could this be happening because of the way my table is setup through the unpivot? If AVERAGEX function calculates everything on a row basis, I think that may be why it's returning 100% on each row... But I'm not sure.
I do think Unpivot is causing an issue,I am surprised to what average is not calculating row-wise.
IF we fix that everything else will be done
Anonymous Gotcha. I will see if I can recreate everything without unpivoting. Thank you for all your help!