Improving measure performance

[luizfjr00]

Hi there!

Hope you are ok! I need some assistance to improve some measures because i really do not have more ideas to do that. I am making a dash with a apportionment problem and i have these measures to get the values. The measures are just below.

Var vProgram = SELECTEDVALUE(d_DeParaProgram[Program EN])

Var rateioComercial = IF(

                        vProgram="Others" || (NOT ISINSCOPE(d_DeParaProgram[Program EN])),

                        [_MED_TOTAL_USD_APPORT_COM],BLANK())

Var rateioExecutivo = IF(

                        NOT ISINSCOPE(d_DeParaProgram[Program EN]),[_MED_TOTAL_USD_APPORT_EXE_ALL]+[_MED_TOTAL_USD_APPORT_EXE_PORT],IF(vProgram="Portugal",[_MED_TOTAL_USD_APPORT_EXE_PORT],IF(vProgram="Not allocated - Executive aircraft",[_MED_TOTAL_USD_APPORT_EXE_ALL],BLANK())))

Var rateioDefesa = IF(

                        vProgram="Not allocated - Defense aircraft" || (NOT ISINSCOPE(d_DeParaProgram[Program EN])),[_MED_TOTAL_USD_APPORT_DEF],BLANK())

Var rateioVSS = IF(vProgram="Not allocated - S&S Aircraft" || (NOT ISINSCOPE(d_DeParaProgram[Program EN])),[_MED_TOTAL_USD_APPORT_VSS],BLANK())

-- Parâmetro Comercial (Usado para ratear em Outros)

Var vParmCOM = SELECTEDVALUE(f_CSI_GFG_BI_TAX_SEG[DSC_APPORT_PARM_COM])

Var vChave = SELECTEDVALUE(DRE[Chave])

Var rateioOutros = IF(

                        vProgram="Ipanema Aircraft" || (NOT ISINSCOPE(d_DeParaProgram[Program EN])),[_MED_TOTAL_USD_APPORT_OTH],BLANK())

Var extraOutros = IF(vParmCOM="Industria"&vChave || vParmCOM="Não alocado UN"&vChave, [_MED_TOTAL_USD_APPORT_EXE_ALL]+[_MED_TOTAL_USD_APPORT_EXE_PORT], BLANK())

Var extraNaoSeg = IF(vParmCOM="NÃO SEGMENTADO"&vChave,[_MED_TOTAL_USD_APPORT_EXE_ALL]+[_MED_TOTAL_USD_APPORT_EXE_PORT],BLANK())

Thanks in advance.

[parry2k]

@luizfjr00 instead of sharing the measure, I would recommend sharing sample data and the expected output Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490