Power BI - How to calculate Sum of a Max

If you don't do this, the totals on the report for this field calculate in Maxes instead of sums.

Create new measure.

CalcQtyAvlbl = SUMX(

SUMMARIZE(Combined_StockBudget, Combined_StockBudget[QtyAvailable], "QtyAvlbl", MAX(Combined_StockBudget[QtyAvailable])),

[QtyAvlbl])