Average Calculation

Hi cghanta 

Can you please try the below DAX.

CALCULATE(
AVERAGE(UPS[Age for Avg]),
ALL(UPS[Location]), 
UPS[Age for Avg] <> 0
)

If this answers your question, kindly mark it as the solution.

Hi cghanta 

You also can try below measure:

CALCULATE(AVERAGE(UPS[Age Avg]),FILTER(ALL(UPS), UPS[Age for Dual UPS Avg] <> 0))

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Both the solutions from xifeng_L and mdaatifraza5556 worked, Thank you both.
I am not sure how to select both the replies as accepted solution