I have many variables that need to be created and they are mostly always relying an if statement.
My reports performance is slowing down drastically.
What is the best practice to optimize performance when using this type of formula?
Should I create a Measure or better to create a Calculated Column?
Should I use SUMX? or is there a performance optimizing alternative?
Go to Solution.
In your example it doesn't look like you need to use SUMX. Instead start with a base measure that sums your price
Price Amount = SUM ( 'Data'[Price] )
Then you use that in measures that apply the filtering you need
Value Actual =
KEEPFILTERS ( 'Data'[Value Category] = "Included in Pricing Model" )
SUMX is an iterator which can be expensive if you use it when you don't need to.
View solution in original post
In my Opinion always creating a measure is best instead of creating additional column in the Data
First Create a measure with SUMX or SUM based on the data and then filter that with other parameters in another measure.
If you have some data sample I can help further
@jdbuchanan71 This sounds great, will most certainly try this. I have base measures for all my measures so will be easy to apply.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!