Forum Discussion
Solved
Surprise - total not adding up correctly
My story begins like many others before me. A simple measure that does exactly what I want: 001 QTY = if([NetQTYR12] = 0, blank(),
CALCULATE(
SUM('Item Availability'[Qty Avl]),
'Item Ava...
Have you looked at this Quick Measure, Measure Totals, The Final Word?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Have you looked at this Quick Measure, Measure Totals, The Final Word?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
What a great resource, thank you! Took maybe 10-15 minutes to play around with the suggested solution based on how my table was set up and really understanding how it was being summraized. Thank you so much!