single value for column error

[Anonymous]

I'm trying to create a column to calculate the following formula:  Profit = ([GPRICE]+CurrentRebates[RebateAmt])-([cost]+[WhsChg]+[FRTCOST]). I am getting an error that: "A single value for column 'RebateAmt' in table 'CurrentRebates' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."  Why is it trying to come up with a single value for the column?  I'm not aggregating the data, I want it to run the formula for each line in my table.  

[v-xjiin-msft]

Hi @Anonymous,

When we create a measure, it is unable to call a table column directly. You need to do aggregation on it. And this is by design.

To resolve your issue, you can try calculated column with your expression.

Thanks,

Xi Jin.

[MFelix]

Hi @Anonymous,

This is happening because you are creating a measure and not a calculated column, since you are refering to CurrentRebates[RebatAmt] it returns this error because a measure need an agregattor on column level.

Check if you are adding a measure or a column.

Regards,

MFelix

[Anonymous · Accepted solution]

I thought that I was using a calculated column.  Anyway, I kept working with it and by using the "Related" function (if that's the correct term), I was able to get the following to work.

Profit = [GPRICE]+RELATED(CurrentRebates[RebateAmt])-[cost]-[WhsChg]-[FRTCOST]

[v-xjiin-msft]

Hi @Anonymous,

I'm glad to hear that you have resolved your issue. Please kindly mark your solution as answer. It will help others with relevant issues find the answer more easily. 

Thanks,
Xi Jin.