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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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/

 

 

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/

 

 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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