Calculated field

[SC22]

Hi All,

I am connecting my data to power bi with amazon redshift (DirectQuery). Can I create new column ? I tried creating new column mentioned below:

Column C = sum (Column A) / sum (Column B)

However, it gives me an error 'sum is not a function'. Is there a way to fix this? Thanks.

[SC22]

Thank you @Shahfaisal ! This worked. 

[Shahfaisal · Accepted solution]

You will need to create a Measure not a calculated column as you are using aggregate functions.

Check this out - https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/