% of Sales Contribution by Month

[thx1137]

Hello,

Trying to come up with a DAX measure to show the % of sales contribution by month in the context of our fiscal year, shown in a matrix that shows months across the columns.

Seems like it should be easy to do, however after multiple attempts, still can't get there.  I can get to % contribution over all time, but not % contribution in the context of the fiscal year.

Any ideas?

[bhanu_gautam · Accepted solution]

Try using this method

TotalSalesPerMonth =
CALCULATE(
SUM(Sales[SalesAmount]),
ALLEXCEPT(Sales, Dates[Month], Dates[FiscalYear])
)

TotalSalesFY =
CALCULATE(
SUM(Sales[SalesAmount]),
ALLEXCEPT(Sales, Dates[FiscalYear])
)

SalesContributionPercentage =
DIVIDE(
[TotalSalesPerMonth],
[TotalSalesFY],
0
)

[thx1137]

...and I want to show several fiscal years worth of data in this matrix visual.

[thx1137]

@bhanu_gautam - thanks, however this is giving me the % contribution of the month in the context of all time...I am trying to get to the % contribution of the month in the context of the fiscal year...

[bhanu_gautam]

@thx1137 , Try using below method

TotalSalesPerMonth =
CALCULATE(
SUM(Sales[SalesAmount]),
ALLEXCEPT(Sales, Dates[Month])
)

TotalSalesAllTime =
CALCULATE(
SUM(Sales[SalesAmount]),
ALL(Sales)
)

SalesContributionPercentage =
DIVIDE(
[TotalSalesPerMonth],
[TotalSalesAllTime],
0
)

Please accept as solution and give kudos if it helps