'Tableau: Average Using Calculated Field

I have the following table and I want to create a calculated field in Tableau that will calculate the average EV quantity. I know I can take the sum and divide it by five to get the average but I want to create a calculated field that sums the five model's quantities and counts the number of models and then divides them to get the average EV quantity.

EV Models Qty. EV Average Qty. Tesla Model S 350 Model X 400 Model 3 150 Model Y 500 CyberTruck 350 Total 1,750 ?

EV Model Inventory

tableau-desktop


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions