Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 *_*
Solved! Go to 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] ) ) )
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] ) ) )
Ty man ;D
sorry I'm a newbie
everything worked