Solved: Calculated Column in Visual

csteves · ‎03-09-2018

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 · ‎03-10-2018

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

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

View solution in original post

deldersveld · ‎03-10-2018

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

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

csteves · ‎03-08-2018

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