.Vlr_PF_Diff =
CALCULATE (
SUMX (
Table01,
Table01[Valor_Compara01]
- CALCULATE (
SUMX ( RELATEDTABLE ( Table02 ), (Table02[Valor_Compara02] )),
FILTER ( Table02 ,
AND(Table02[Var_A] = Table01[Var_A],
AND(Table02[Var_B] = Table01[Var_B] ,
Table02[Var_C] = Table01[Var_C] ))
)
)
)
)
No comments:
Post a Comment