AverageX Total average not showing correct value

[ayush_mriti]

Hi All,

The AverageX output average is not showing the correct values. Here is the screenshot. here the total average output 35 (average2xfinal) is not correct, the correct output should be (10+83+4+129)/4 = 56.5.

Here is the calculation for AverageX :

average2xfinal = AVERAGEX(Kanban_output, Kanban_output[LODcycletime]/ Kanban_output[LODissuecount])

And LOD cycletime: 

LODcycletime = SUMX(

    VALUES('Kanban_output'[SnapshotMonth]),

    CALCULATE(

        sum('Kanban_output'[CycleTime]),

        ALLEXCEPT('Kanban_output',

         'Kanban_output'[SnapshotMonth],

         'Kanban_output'[atr_key],

          'Kanban_output'[l3id])

    )

)

Appreciate for your help.

[ayush_mriti]

Perfect ! Thanks a lot 

[FreemanZ · Accepted solution]

hi @ayush_mriti ,

try like:

average2xfinal = 

AVERAGEX(VALUES(Kanban_output[atr_key]), Kanban_output[LODcycletime]/ Kanban_output[LODissuecount])