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
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
