Forum Discussion

inescosta's avatar
inescosta
Advocate II
9 years ago
Solved

Multiplying between Tables

Hello,   I am having problems with these tables. I need to calculate the (af_escalaItem[valor]*af_servprod_criterios[peso]) for each af_aval_id, but I just can't seem ...
  • inescosta's avatar
    inescosta
    9 years ago

    Hi v-ljerr-msft,

     

    Thank you so much for the help but using the formula sumx returns the sum of all the values but that is not what I intended. I think this is my solution:

     

    column=RELATED(af_escalaItem[valor]) *

    CALCULATE(

        VALUES(af_servprod_criterios[peso]),

        FILTER(

            af_servprod_criterios,

            af_avaliacaoItens[af_criterio_id] = af_servprod_criterios[af_criterio_id] &&

            RELATED(af_fornecedorAvalia[af_servprod_id]) = af_servprod_criterios[af_servprod_id]

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi inescosta,

 

According to the screen shoot of your table relationships above, you should be able to use the formula below to create a new calculate column in "af_avaliacaoItens" table to to calculate the (af_escalaItem[valor]*af_servprod_criterios[peso]) for each af_aval_id.:smileyhappy:

NewCalculateColumn = RELATED ( af_escalaItem[valor] ) * SUMX ( RELATEDTABLE ( af_servprod_criterios ), af_servprod_criterios[peso] )

 

Regards

inescosta's avatar
inescosta
Advocate II
9 years ago

Hi v-ljerr-msft,

 

Thank you so much for the help but using the formula sumx returns the sum of all the values but that is not what I intended. I think this is my solution:

 

column=RELATED(af_escalaItem[valor]) *

CALCULATE(

    VALUES(af_servprod_criterios[peso]),

    FILTER(

        af_servprod_criterios,

        af_avaliacaoItens[af_criterio_id] = af_servprod_criterios[af_criterio_id] &&

        RELATED(af_fornecedorAvalia[af_servprod_id]) = af_servprod_criterios[af_servprod_id]