06-19-2018 11:47 AM
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).
06-19-2018 12:02 PM
That's weird, It is working at my end: Can you please write 2 measure separately
Measure 1 : AVERAGEx(zero,Zero[Column1]/Zero[Column2])
Measure 2:= CALCULATE(AVERAGEx(zero,Zero[Column1]/Zero[Column2]) ,ALLEXCEPT(Zero,Zero[Quarter],Zero[Year]))
and paste your entire column list here...
06-19-2018 12:20 PM - edited 06-19-2018 12:22 PM
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.