Hi, I have a measure that calculates the average value of inventory for each item in inventory. Avg Inventory Value = Cost per unit * Avg Inventory balance The problem is while each individual item is calculating correctly, the grand total should be a sum of Avg Inventory value not the grand tot…

I don’t know why it did not work for you… I simplified the dax further and have attached the pbix file. pls have a look. = Avg Cost Bal 2 = IF(HASONEVALUE(Items[Item]),[Avg Cost Bal] , SUMX(VALUES(Items[Item]), [Avg Cost Bal])) Refer screen shot below and i have also updated your pbix file [im…

Want grand total of average function to be a sum not an average

DAX DAX Calculations

BrianJ May 6, 2020, 2:45am 3

@MathewA,

Please check out this thread below. I think it provides a detailed solution to a scenario that matches yours exactly:

Brian