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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
amirabedhiafi
Impactful Individual
Impactful Individual

Measure vs Calculated Column when applying a formula

I have the following table : 

 

amirabedhiafi_0-1619591716338.png

I have this formula to calculate a measure :

 

(IO_WITHOUT_ERROR/IO_NIO)*100
 
When I use a calculated column, it works :
CalculatedColumn = (MyTable[IO_WITHOUT_ERROR]/MyTable[IO_NIO])*100
 
but when I use it for a measure, I get the following :
 
amirabedhiafi_1-1619591952299.png

 

I want to understand the difference between Measure vs Calculated Colum in this context ?

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@amirabedhiafi , Measure can take the measure of summarized /aggregated columns

 

example

divide(Sum(MyTable[IO_WITHOUT_ERROR]), Sum(MyTable[IO_NIO]))*100

 

Calculated column calculations are stored. Measure calculations are done runtime 

refer: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@amirabedhiafi , Measure can take the measure of summarized /aggregated columns

 

example

divide(Sum(MyTable[IO_WITHOUT_ERROR]), Sum(MyTable[IO_NIO]))*100

 

Calculated column calculations are stored. Measure calculations are done runtime 

refer: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

So basically it is related to the row context and the result of the row context ?

 

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors