Forum Discussion
Sum based on selection
I wasn't sure exactly how to title this question. I have a table that has Four columns, Type, Version, Month and quantity. In January, all twelve months are loaded and each month type is Forecast...
Could you do something where you Calculate the Actuals and add in the selected forecast?
measure = CALCULATE(SUM(Quantity),Type="Actuals")+CALCULATE(SUM(Quantity),Type="Forecast",Version=SELECTEDVALUE(Version))
You may want to break up those into individual measures or use variables but the idea is there.
Thank you, I will look into selected value, I have used it before and it is very handy.
