Forum Discussion

AlexAlberga727's avatar
AlexAlberga727
Resolver II
5 years ago
Solved

Measure * Calculated Column - Not working as expected

Hello!   I am attempting to multiply a measure by a calculated column and am having issues.   I have a measure [Total Units Sold], and a feild called ELC.   Total Units Sold = SUM( [QTY Sold] )...
DAX
Measures
  • nandic's avatar
    nandic
    5 years ago

    Hi AlexAlberga727 ,
    Measure expectes you to use some kind of aggregation (sum, min, max, first...), it can't accept original column value when combining with another measure.
    In order to make it work, use sumx function. It allows you to multiply amount with another column.
    Here is a nice explanation: https://exceleratorbi.com.au/use-sum-vs-sumx/ 

    Regards,
    Nemanja Andic

nandic's avatar
nandic
Resident Rockstar
5 years ago

Hi AlexAlberga727 ,
Measure expectes you to use some kind of aggregation (sum, min, max, first...), it can't accept original column value when combining with another measure.
In order to make it work, use sumx function. It allows you to multiply amount with another column.
Here is a nice explanation: https://exceleratorbi.com.au/use-sum-vs-sumx/ 

Regards,
Nemanja Andic

AlexAlberga727's avatar
AlexAlberga727
Resolver II
5 years ago

nandic Thanks for the article. Using SUMX() was the key.