s
1 Topic
DAX performance. Lots of what if parameters affecting measures.
Hi all, I have a Power BI file with a tab where there are 14 segmentations (14 what if parameters) and I have a measure that use all those segmentations: This is the measure I have: ------------------------------------------------ INCENTIVE FEE_TRAMO = var agop_por = SELECTEDVALUE('%AGOP'[Value]) var por_min = SELECTEDVALUE('%min'[Value]) var por_int = SELECTEDVALUE('%int1'[Value]) var por_int2 =SELECTEDVALUE('%int2'[Value]) var por_max = SELECTEDVALUE('%max'[Value]) var IF11 = SELECTEDVALUE(IF1[Value]) var IF22 = SELECTEDVALUE(IF2[Value]) VAR IF33 = SELECTEDVALUE(IF3[Value]) VAR IF44 = SELECTEDVALUE(IF4[Value]) VAR IF55 = SELECTEDVALUE(IF5[Value]) return SWITCH(TRUE(); agop_por<por_min || [G.O.P_TOT %]<por_min;IF11 ; (agop_por> por_min && agop_por<por_int) || ([G.O.P_TOT %]> por_min && [G.O.P_TOT %]<por_int);IF22; (agop_por>por_int && agop_por< por_int2) ||([G.O.P_TOT %]>por_int && [G.O.P_TOT %]< por_int2);IF33; (agop_por>por_int2 && agop_por< por_max) ||([G.O.P_TOT %]>por_int2 && [G.O.P_TOT %]< por_max) ;IF44; agop_por>por_max|| [G.O.P_TOT %]>por_max;IF55) ------------------------------------------------------------- The problem is that when I change any of the what if parameters values it takes almost 2 minutes to update the visual.. how can I make more optimized my measure? (G.O.P_TOT % is another measure from another table) Thank you in advance. Andrea.Solved2.3KViews0likes5Comments