Calculated Column in Visual

[csteves]

Hello,

I am trying to create a calculated field to show a percentage based off actual sales to planned sales. I get the calculated field, however when I put it as a visual, I only have choices to average, sum, median, variance, etc. I just want to see the % by selected filters, which would be the sum of actual sales divided by planned sales. I appreciate any help. 

Thanks 

[deldersveld · Accepted solution]

Create a new measure similar to the following and set the format to %:

= DIVIDE(SUM('Table'[Actual]), SUM('Table'[Planned]))

[csteves]

Hello,

I am trying to create a calculated field to show a percentage based off actual sales to planned sales. I get the calculated field, however when I put it as a visual, I only have choices to average, sum, median, variance, etc. I just want to see the % by selected filters, which would be the sum of actual sales divided by planned sales. I appreciate any help. 

Thanks