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

Anonymous if that is the structure of the data which is very less likely, I will unpivot and then work on it, this is not the right shape of the data for the Power BI.