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])
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Assuming the data is laid out like this: 

IDFixedID2Fixed2
50.52100.75



I used these measures: 

Multiply ID 1 and Fixed 1 = SUMX('Table', 'Table'[Fixed] * 'Table'[ID])
Multiply ID 2 and Fixed 2 = SUMX('Table', 'Table'[Fixed2] * 'Table'[ID2])
Add Values = SUMX('Table', [Multiply ID 1 and Fixed 1] + [Multiply ID 2 and Fixed 2])