Using Sum With Multiple Column

[Anonymous]

• I have to sum of the VALOR Column where the NR_IT_PED of the TABLE B is equal to the NR_IT_PED of the TABLE A

I have to sum of the VALOR Column where the NR_IT_PED of the TABLE B is equal to the NR_IT_PED of the TABLE A

Help Please  *_*

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Hopefully this measure in TableA will do your job

Measure =
CALCULATE (
    SUM ( TableA[VALOR] ),
    INTERSECT ( ALL ( TableA[NR_IT_PED] ), ALL ( TableB[NR_IT_PED] ) )
)

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Hopefully this measure in TableA will do your job

Measure =
CALCULATE (
    SUM ( TableA[VALOR] ),
    INTERSECT ( ALL ( TableA[NR_IT_PED] ), ALL ( TableB[NR_IT_PED] ) )
)

[Anonymous · Accepted solution]

Ty man ;D

sorry I'm a newbie 

everything worked