Como tornar essa Expressão mais leve?

[Edmundo]

SUM(SELECT(ATENDIMENTO[VALOR],AND([FPG]="DEBITO",[DATA]=[_THISROW].[DATA]))) + SUM(SELECT(Atendimento[VLM],AND([PGM]
=
" DEBITO",[DATA]=[_THISROW].[DATA])))
+
SUM(SELECT(CXENTRA[VALOR],AND([FPG]="DEBITO",[DATA]=[_THISROW].[DATA])) )
+
SUM(SELECT(ATENDIMENTO[VLAD],AND([FPG]="DEBITO",[DATA]=[_THISROW].[DATA])))

[Joseph_Seddik]

1. In your ATENDIMENTO table, make a virtual column that sums the three VALOR, VLM, and VLAD values together. Name it for example vvvSum. So your expression will be:
     
   SUM( SELECT(ATENDIMENTO[vvvSum],
          AND([FPG]="DEBITO", [DATA]=[_THISROW].[DATA])
   )) + 
   SUM( SELECT(CXENTRA[VALOR],
          AND([FPG]="DEBITO", [DATA]=[_THISROW].[DATA])
   ))
     
2. In both your ATENDIMENTO and CXENTRA tables, establish references to the table where you are doing this calculation. Your expression will then be:
   
   SUM([Related ATENDIMENTOs][vvvSum]) + SUM([Related CXENTRAs][VALOR])