Forum Discussion

ayush_mriti's avatar
ayush_mriti
Helper 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
    Super User
    1 year ago

    hi ayush_mriti ,

     

    try like:

    average2xfinal = 

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