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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mngma0102
Frequent Visitor

Dividing Calculated Columns Resulting in Same Value for each row

Hello, 

 

I have 2 calculated columns, Open Units and Allocated Units. I am trying to calculate the Allocated % through this calculation:  DIVIDE(Allocated Units, Open Units, 0).  Instead of the correct value, am getting the same value for each row like below. I am now sure where this % is coming from. 

mngma0102_0-1710963225104.png

 

How can I get the calculation to work? Thank you in advance. 

1 ACCEPTED SOLUTION

4 REPLIES 4
lbendlin
Super User
Super User

Are you trying to create another calculated column, or a measure?

I am trying to create a measure 

lbendlin_0-1710982698022.png

 

Thank you it worked!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors