Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous Gotcha. I will see if I can recreate everything without unpivoting. Thank you for all your help!