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))

     

     

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

JuanPabloCarr  what is the desired end goal based on the sample data

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!