Exel guru but Power BI newbie needs assistance with Measures

[Anonymous]

Hello Power BI gurus,

I am going round-and-round in circles trying to figure out how to get the results I want in Power BI.  Seems like it should be simple (it certainly is using pivot tables!) but I'm just not knowledgeable enough about DAX or measures to know the trick yet.  

I have a table that looks like this:

I added this table to a Power BI Matrix, and now I want to add a column called "Conversions" which is simply the calculation "Sales/Calls" as a percentage.  Then I want to aggregate it by region, like shown here in this pivot table (where I added "Conversions" as a calculated field):

But I cannot figure out how to do this in Power BI! I keep coming up with weird percentages that don't make sense.  I've done some research and I get the sense that what I want is a measure and not a calculated column, but I'm not at all familiar with DAX enough to know what the correct syntax is to accomplish this.  I'm sure this is easy once you know how, so any help will be greatly appreciated!

[jthomson · Accepted solution]

What does Conversion = divide(sum[sales],sum[calls]) give you?

[jthomson · Accepted solution]

What does Conversion = divide(sum[sales],sum[calls]) give you?

[Anonymous]

Here's what I get with that measure:

[hnguy71 · Accepted solution]

Conversions = DIVIDE(SUM(Table1[Sales]), SUM(Table1[Calls]))

[Anonymous]

Thank you jthomson & hnguy71!  Those measures worked perfectly once I changed the formatting.  I was unaware of the DIVIDE function, which is where I was going astray.  Thanks again!