Forum Discussion

ayush_mriti's avatar
ayush_mriti
Icon for Helper I rankHelper I
1 year ago
Solved

AverageX Total average not showing correct value

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.

 

Need Help
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi ayush_mriti ,

     

    try like:

    average2xfinal = 

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

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    1 year ago

    hi ayush_mriti ,

     

    try like:

    average2xfinal = 

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