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...
This will be tricky due to the negative values for your percentages. Can you specify exactly what result you expect by annotating the screenshot above?
At the end of the day, I want to be able to chart out, or show in a trend the "Contribution %" column. This allows me to see the overall sales growth for the company of (2.2%), but also allows me to isolate the biggest movers when digging deeper. So, a particular state may have had a large growth %, but the overall dollars are a small part of the total, so it helps isolate where to dig deeper when analyzing.
Hopefully that makes sense.
- Ah yes, sorry, I see now. So the table is what you want, sorry, I thought that was what you had already achieved. Can you please supply your current DAX that you are using for the Sales LY and measures that you say are working? Also what tables and columns you have in your data model to work with.
Getting the the percentage correct is a matter of finding the right combination of filter functions, such as ALL and ALLEXCEPT
Also, depending on what totals row value you want, you may need to make some slight adjustments.