Forum Discussion
Improving measure performance
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.
1 Reply
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
