Forum Discussion

JuanPabloCarr's avatar
JuanPabloCarr
New Member
3 years ago
Solved

distinct add with repeated values

Hi, i got the following problem: We have purchase orders for materials, these are received little by little by the suppliers, so repeated rows of the same order are created as the materials are re...
  • smpa01's avatar
    smpa01
    3 years ago

    JuanPabloCarr 

    Measure = CALCULATE(SUMX(VALUES(tbl[|money|]),tbl[|money|]),ALL(tbl))

     

     

JuanPabloCarr's avatar
JuanPabloCarr
New Member
3 years ago

i need a measure to sum 450 (1wood + 1door + 1windows) and not 850 (2wood + 1door +2windows)

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

JuanPabloCarr 

Measure = CALCULATE(SUMX(VALUES(tbl[|money|]),tbl[|money|]),ALL(tbl))

 

 

  • JuanPabloCarr's avatar
    JuanPabloCarr
    New Member
    3 years ago

    That works for me, thanks!