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

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]))

2 Replies

  • deldersveld's avatar
    deldersveld
    Resident Rockstar
    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