Forum Discussion
Sales Growth Contribution %
Hey everyone, I am a first time poster here, and I have searched for what I am looking for, but haven't been able to find a solution. However, if it has been solved before, please point me in th...
Claymation , Try like
% of Growth = divide([Sales Growth $], calculate([Sales Growth $] , allselected(Table))
or
% of Growth = divide([Sales Growth $], calculate([Sales Growth $] , all(Table))
Here is what I have as the two steps to get me there...however, when I compare to the solution that I have in Excel, it appears to be off.
State % of Total = DIVIDE(
SUM(location_sales_summary_v[net_sales_prev_day]),
CALCULATE(sum(location_sales_summary_v[net_sales_prev_day]),all(location_finance_xref_v[state])))
Then the following is what I am showing in the chart/table.
SSS Contribution % (State) = [State % of Total]*[SSS Growth %]
SSS Growth % is calculated as:
SSS Growth % =
DIVIDE(
SUM('location_sales_summary_v'[net_sales_prev_day]),
SUM('location_sales_summary_v'[net_sales_prev_day_prior_year])
)-1