Forum Discussion

csteves's avatar
csteves
Frequent Visitor
8 years ago
Solved

Calculated Column in Visual

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...
Need Help
  • deldersveld's avatar
    deldersveld
    8 years ago

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

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

csteves's avatar
csteves
Frequent Visitor
8 years ago

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