cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bangerz253 Frequent Visitor
Frequent Visitor

Create new column for measure?

power bi.PNG

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
jar2019 Regular Visitor
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
jar2019 Regular Visitor
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:

power bi.PNG

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!!

 

 


 

jar2019 Regular Visitor
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:

power bi.PNG

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!!

 

 


 

bangerz253 Frequent Visitor
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?

jar2019 Regular Visitor
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)

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 110 members 1,571 guests
Please welcome our newest community members: