Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
Solved! Go to Solution.
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"
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!!
@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?
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"
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!!