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+8...
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])

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])