slow reports
1 Topic
Calculate Statement - Slow Table Load with many informations
Hi guys, I have created this measure (Measure1) that actually obtain the result I want to discover and gives not many problem in limited filter context like table with few rows. Measure1= CALCULATE( [Measure0], FILTER( 'Accounting', 'Accounting'[Fiscal Period] >= RELATED( 'Price Lists'[Fiscal Period] ) )) The problem comes when I add more information in the table report like customer, item, country etc. lead to a very slow loading. The expression within calculate is made by the following measure: Measure0 = SUMX ( FILTER ( 'Price Lists', 'Price Lists'[Old Price]> 0 ), IF ( [ASP] > [Old Price], ( [ASP] - [Old Price] ) * [Quantity], BLANK() )) From the Measure 0 I am creating a context where from the price list I am creating a table with only the values "old price" area greater than zero and then creating and then the if statement. The measure 1 is using the measure 0 only where is retrieving the fiscal period from the price list with related. Can someone help me maybe with a best practice to fix the formula? Really thank you in advance for your help, Regards, ESSolved1.7KViews0likes5Comments