Forum Discussion

rkilwine's avatar
rkilwine
New Member
10 years ago
Solved

Creating a new measure - basic calculation

Hello!   I am new to Power BI and woudl like to create a measure on two of my columns to create a percetage.   I am working with two columns on Pass attempted vs Passes Completed. from my underst...
  • Sean's avatar
    Sean
    10 years ago
    Because you are doing a Measure you need to aggregate the Values - just add SUM

    Percentage = DIVIDE ( (SUM(column)), (SUM(other)), 0)
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago
Because you are doing a Measure you need to aggregate the Values - just add SUM

Percentage = DIVIDE ( (SUM(column)), (SUM(other)), 0)
rkilwine's avatar
rkilwine
New Member
10 years ago

Hi Sean - you are a LIFE SAVER! 

 

and you are right in order to create the accurate measure I need to divide completed by attempted.

 

Can you elaborate a little more on the purpose of addind the SUM in front of the column name? I am unfamiliar with this function. Maybe some alternate...(looking for the name of what to call SUM)...versions of those? Like what would the difference be between SUM and COUNT in that same formula?

 

Again - Thank you so much! You just unlocked Measures for me.