Forum Discussion

Mewan117's avatar
Mewan117
Frequent Visitor
3 years ago
Solved

AVERAGEX giving the wrong value

Hello Everyone,  In the below table, I have calculated the Avg Time: Per Item with a measure. Which is the manifested_timings_total/Total items per orderID. Then I wanted the average of the Avg Time...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Mewan117 ,

     

    I think you can try to create a virtual table in your measure. Measure may look like as below.

    Avg of the Avg =
VAR _SUMMARIZE =
    SUMMARIZE (
        'Table',
        'Table'[Statin ID],
        'Table'[Order ID],
        "Avg", [Avg Time: Per Item]
    )
RETURN
    AVERAGEX ( _SUMMARIZE, [Avg] )

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Mewan117 ,

 

I think you can try to create a virtual table in your measure. Measure may look like as below.

Avg of the Avg =
VAR _SUMMARIZE =
    SUMMARIZE (
        'Table',
        'Table'[Statin ID],
        'Table'[Order ID],
        "Avg", [Avg Time: Per Item]
    )
RETURN
    AVERAGEX ( _SUMMARIZE, [Avg] )

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Mewan117's avatar
Mewan117
Frequent Visitor
3 years ago

That worked! Thank you very much!