Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can you please try this

 

: AverageX(AllExcept(Table,Year,Quarter),(positivefeedback/Allgroups*100))

 

* In Place of Table keep your table name.

 

Thanks,

Aditya

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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).

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I think this should work :

         

        avg = CALCULATE(AVERAGEx(zero,Zero[Column1]/Zero[Column2]) ,ALLEXCEPT(Zero,Zero[Quarter],Zero[Year]))

         

        Note : Zero is table name I have created