Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AlexAlberga727
Resolver II
Resolver II

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] )

ELC is a static numerical value which is pulled in and related to my SKUs.

    Within my product table this value is pulled in from a related table: ELC = Related ( [ 'dELC'[ELC] )

 

 

I am attempting to simply take the Total Units Sold and multiply this by the ELC value. Sounds simple, might be.. but It's not working for me as expected.

 

exmple_02172021.png

 

When I attempt to create a new measure and multiple the two values the ELC field is not being populated within the formula bar (See phots).

 

 exmple_2_02172021.png

 

Is there a reason for this? Is there a way I can do the calculation I am attempting?

 

Let me know your thoughts, thanks!

 

1 ACCEPTED SOLUTION
nandic
Memorable Member
Memorable Member

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

View solution in original post

2 REPLIES 2
nandic
Memorable Member
Memorable Member

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 Thanks for the article. Using SUMX() was the key.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors