Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculated Column Not Working

I have a calculated column named [Sales Amount Total] which is the SUM of two value columns [Presales] and [Vans].   I then created a new calculated column named [Binary] that converts any no...
Need Help
Adescrit's avatar
Adescrit
Impactful Individual
3 years ago

Hi Anonymous 

 

The following DIVIDE function should return the percentage calculation you're looking for:

DIVIDE( SUM( Table[Binary]) , COUNT( Table[Binary] ) )


Note I've made a couple of extra change to the formula here, besides changing CALCULATE to DIVIDE:

  1. Added the table name before [Binary]. Provided you have created a calculated column and not a measure you will need to add the table and column name in this format: Table[Binary]
  2. Added brackets (parentheses) around the column name, so SUM( Table[Binary] ) and COUNT( [Binary] )

If this doesn't work, double-check that you have created a column rather than a measure. If it is a measure you have created, you can't COUNT or SUM a measure, you would need instead to create two separate measures that calculate the SUM and COUNT of the required column.