Average of Percentage

[Anonymous]

Can someone help me get the average of percentage instead of the sum of produced divided by the sum of planned. Thank you.

[Anonymous]

Thank this worked. For anyone who wants to know. I had to work off 1 single table instead of difference onces. I probably could of with RELATED function but this was was easier.

[Anonymous]

They are not in the same table.

Production Report: Shows the Produced

Planning Report: Shows the Planned Amount

FG Item Table: Shows the Item No

Calendar Table: Shows the Week Starting.

I can show you the relationship

[tamerj1 · Accepted solution]

@Anonymous 

Please try

ATS =
AVERAGEX (
    SUMMARIZE ( 'Table', 'Table'[Starting Week], 'Table'[SKU] ),
    DIVIDE ( [Completed], [Planned] )
)