Forum Discussion

JasiExpert's avatar
JasiExpert
Regular Visitor
5 years ago
Solved

Measure (Multiply 2 columns from different tables) correct on lowest level but totals are too high

I am a beginner, just had a 2 days training and started with my first projects. Now I am facing the following problem. I want to multiply 2 columns from 2 different tables.  The Measure "PlanBedarfSt...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    In general, (a + b + c) * (x + y + z) = a*x + a*y + a*z + b*x + b*y + b*z + c*x + c*y + c*z is not the same as a*x + b*y + c*z. I suspect you want the latter but your attempts are written like the former.

     

    It's not completely clear to me how all your data tables are related so it's hard to say exactly, but you should be able to get the result you want using SUMX a bit like this:

    _PlanBedarfStk =
SUMX ( VALUES ( vw_aevo[ArtikelNr] ), [_PlanStk] * [_MEKxStk] )

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

In general, (a + b + c) * (x + y + z) = a*x + a*y + a*z + b*x + b*y + b*z + c*x + c*y + c*z is not the same as a*x + b*y + c*z. I suspect you want the latter but your attempts are written like the former.

 

It's not completely clear to me how all your data tables are related so it's hard to say exactly, but you should be able to get the result you want using SUMX a bit like this:

_PlanBedarfStk =
SUMX ( VALUES ( vw_aevo[ArtikelNr] ), [_PlanStk] * [_MEKxStk] )