Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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
)
Proud to be a Super User! | |
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
)
Proud to be a Super User! | |
...and I want to show several fiscal years worth of data in this matrix visual.
@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...
@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
Proud to be a Super User! | |
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |