Hello,
As shown in the illustrative photo below, I'm trying to compute the CONTRIBUTION for each company (see red): (2017 sales value - 2016 sales value) / (2016 Total Sales).
I have been able to create a new measure for the 2017-2016 sales delta for the numerator, but cannot figure out how to create a new measure that will display the Sum of the 2016 sales column. Please note that the values in the columns will be changing depending on how I filter the data using the Slicer - I need this column total to dynamically update.
I appreciate the help!
RR
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
