Forum Discussion

leamsi-alvarado's avatar
leamsi-alvarado
Regular Visitor
2 years ago
Solved

Multiply Measure and column, before sum

Hello, i need to multiply a measure with a column, the problem is that it sums first, and then it does de mutliplication, this is the dax code im currently using:  Variance per volume= 'PBI_ASN_Volu...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I would try it this way, 

     

    Variance per volume = SUMX(
    'PBI_ASN_Fixed_Cost',
    'PBI_ASN_Fixed_Cost'[FixedCost] * 'PBI_ASN_Volume_Budget'[Variance Budget]
)

     

    This could also help 

    Variance per volume = SUMX(
    'PBI_ASN_Fixed_Cost',
    'PBI_ASN_Fixed_Cost'[FixedCost] * RELATED('PBI_ASN_Volume_Budget'[Variance Budget])
)
parry2k's avatar
parry2k
Super User
2 years ago

leamsi-alvarado the solution Anonymous  provided will work assuming there is a relationship between the tables, and also an important part is how these tables are related. Is it many to many or one to many relationship and which side is the one side?

 

Just having DAX will not do anything until there is a clear understanding of the relationship. My 2 cents.