Forum Discussion
Solved
Create a measure with value from another table
I need to create a measure which is the % of a sales goal for a salesperson. The total sales for a person is a Measure in a transaction table - TotalTYDSales. The sales goal, YTDPlan, is in a sepa...
That worked. Thank You!
It is a column Plan_YTD_Sales = [Months]*[Plan_Monthly_Sales]
You only need to add a aggregation in the % Formula.
YTD % of Plan = udService_Sales[TotalYTDSales]/sum(vbudServiceSalesPlan[Plan_YTD_Sales])
Assuming that ServiceSalesPlan have only 1 year. If is not you i recommend create a measure to filter the year.
That worked. Thank You!