cancel
Showing results for
Did you mean:
Frequent Visitor

## Create new column for measure?

Hello, I'm looking to create a new column for a conversion rate. Ex.  In Cali of April, there is 136 TRUE and 364 Total, so I want a new column that does 136/364 and so on for FALSE, SERVICE. Also, Is there a reason why PowerBI is adding incorrectly? In WA on the blank row, if u add 76+22+3=101 , not 101? If anyone is able to help me, I'd be greatly appreciative!!

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

## Re: Create new column for measure?

I see:

1) right click anywhere in the table dropdown on the right.

2) click quick measure (also in the ribbon on home->top right)

3) use the dropdown in the quick measure pop up to select your operation

So you need to create a total by category measure first

(this will be the sum of all your columns) by state

Then you can create another quick measure that divides the "total measure" we just created by the columns Tru, Fals, Etc. using the division operator.

You can also create a new column but this can take up a lot of space if you have a lot of records.

You could also use DAX and use the "measure" instead of "quick measure"

Measure Total = SUMX('Table','table'[False]+'Table'[True]...etc)
4 REPLIES 4
Regular Visitor

## Re: Create new column for measure?

Are you rounding any of the columns? That might be why it is not adding correctly.

@bangerz253 wrote:

Hello, I'm looking to create a new column for a conversion rate. Ex.  In Cali of April, there is 136 TRUE and 364 Total, so I want a new column that does 136/364 and so on for FALSE, SERVICE. Also, Is there a reason why PowerBI is adding incorrectly? In WA on the blank row, if u add 76+22+3=101 , not 101? If anyone is able to help me, I'd be greatly appreciative!!

Regular Visitor

## Re: Create new column for measure?

I am thinking you should just create a quick measure and use the division operator. Then use True as numerator and Total as denominator. This will keep your refresh speeds fast and efficient only pulling the calculations that you need to query.

@bangerz253 wrote:

Hello, I'm looking to create a new column for a conversion rate. Ex.  In Cali of April, there is 136 TRUE and 364 Total, so I want a new column that does 136/364 and so on for FALSE, SERVICE. Also, Is there a reason why PowerBI is adding incorrectly? In WA on the blank row, if u add 76+22+3=101 , not 101? If anyone is able to help me, I'd be greatly appreciative!!

Frequent Visitor

## Re: Create new column for measure?

@jar2019  the total is automatically calculated by Power Bi based on my groupings and count. I'm not sure how I would do the quick measure?

Regular Visitor

## Re: Create new column for measure?

I see:

1) right click anywhere in the table dropdown on the right.

2) click quick measure (also in the ribbon on home->top right)

3) use the dropdown in the quick measure pop up to select your operation

So you need to create a total by category measure first

(this will be the sum of all your columns) by state

Then you can create another quick measure that divides the "total measure" we just created by the columns Tru, Fals, Etc. using the division operator.

You can also create a new column but this can take up a lot of space if you have a lot of records.

You could also use DAX and use the "measure" instead of "quick measure"

Measure Total = SUMX('Table','table'[False]+'Table'[True]...etc)

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 110 members 1,571 guests
Recent signins: