Average Formula

Question

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 &amp; quarter:

anonymous · Answer

Can you please try this&nbsp;: AverageX(AllExcept(Table,Year,Quarter),(positivefeedback/Allgroups*100))&nbsp;* In Place of Table keep your table name.&nbsp;Thanks,Aditya

anonymous · Answer

Anonymous&nbsp;I've tried doing it this way but for whatever reason it comes out to 100% for every month:

anonymous · Answer

Can you please post your calculation and few rows sample data here..

anonymous · Answer

Anonymous&nbsp;Sure:&nbsp;&nbsp;And if it makes a difference, I unpivoted my original table to look like this:&nbsp;&nbsp;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).

anonymous · Answer

I think this should work :&nbsp;avg = CALCULATE(AVERAGEx(zero,Zero[Column1]/Zero[Column2]) ,ALLEXCEPT(Zero,Zero[Quarter],Zero[Year]))&nbsp;Note : Zero is table name I have created

Forum Discussion

Average Formula

10 Replies

Related content

Average formula

If formula

formula

DAX Formula Help

Average and Moving Average