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! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |