DAX takes 60 seconds to load with many what if numeric parameters
Hi, I have the following dax that uses measures where i addded the user numeric parameters with our values and i want to put them in my matrix but the performance is super slow, here is the dax of the final measure. Total_Customers_2 = var AllActuals = [All Actuals] var notselected_customers = [notselected_customers] return IF( SELECTEDVALUE('SBI Actuals Agg (x100)'[Line of Items]) = "[NE]", FORMAT(CALCULATE([Nes_time_new] + notselected_customers+AllActuals), "#,##0"), IF( SELECTEDVALUE('SBI Actuals Agg (x100)'[Line of Items]) = "[L66]", FORMAT(CALCULATE([L6_time_new] + notselected_customers+AllActuals), "#,##0"), IF( SELECTEDVALUE('SBI Actuals Agg (x100)'[Line of Items]) = "[L66b]", FORMAT(CALCULATE([L6b_time_new] + notselected_customers+AllActuals), "#,##0"), IF( SELECTEDVALUE('SBI Actuals Agg (x100)'[Line of Items]) = "[C11]", FORMAT(CALCULATE([c1_time_new_] + notselected_customers+AllActuals), "#,##0"), IF( SELECTEDVALUE('SBI Actuals Agg (x100)'[Line of Items]) = "[L110]", FORMAT(CALCULATE([L10_time_new] + notselected_customers+AllActuals), "#,##0"), IF( SELECTEDVALUE('SBI Actuals Agg (x100)'[Line of Items]) IN { "[GE]", "[L66a]", "[L1]", "[L2]", "[L3]", "[Net Weight]" }, FORMAT([Fixed_Date_Total_Customers]+AllActuals, "#,##0"), IF( SELECTEDVALUE('Sorting Index'[Line]) = "C1", FORMAT([c1PerNes_total], "#0.00%"), IF( SELECTEDVALUE('SBI Actuals Agg (x100)'[Line of Items]) = "[L14]", FORMAT(CALCULATE([L14_time_new] + notselected_customers+AllActuals), "#,##0"), BLANK() ) ) ) ) ) )))
