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:
Can you please try this
: AverageX(AllExcept(Table,Year,Quarter),(positivefeedback/Allgroups*100))
* In Place of Table keep your table name.
Thanks,
Aditya
Anonymous I've tried doing it this way but for whatever reason it comes out to 100% for every month:
Can you please post your calculation and few rows sample data here..
Anonymous Sure:
And if it makes a difference, I unpivoted my original table to look like this:
So everything in the last 2 columns originally had their own column. I don't know if the unpivot throws this kind of formula off. So positive feedback would be everything that consists of a positive sounding value (strongly agree, agree, happy, very happy).