Forum Discussion
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...
Create a new measure similar to the following and set the format to %:
= DIVIDE(SUM('Table'[Actual]), SUM('Table'[Planned]))
Create a new measure similar to the following and set the format to %:
= DIVIDE(SUM('Table'[Actual]), SUM('Table'[Planned]))