Forum Discussion

ihogye's avatar
ihogye
New Member
3 years ago

columns summary

Hi,

 

Can You help me define the rith setup of calculation about this sample file:

 

After multiplication of Cap & Qty the sum of colum not rigth, but I understant why show / calculate this sum, but I need to modify to the multiplication of calculated cells... as the 2nd table showing. Can You help me?

 

 

Thanks, István

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    ihogye , Try should try like

     

    Sumx(Values(Norm[Model]), calculate(Sum(Prod[Qty]) *Sum(Norm[CAP1) ) )

    You might need common dim table

     

    if the relationship is 1 to Many from Norm to Prod

    Sumx(Prod, Prod[Qty]* related(Norm[CAP1]) )

    • ihogye's avatar
      ihogye
      New Member
      3 years ago

      Thanks a Lot, it is working! István