Single value for column error

[aishak12]

Does anyone know what this error details and how to resolve this.

[v-xiaoyan-msft · Accepted solution]

Hi@aishak12,

Please try measure like this :

GrossBillingsIF = IF( Max('table'[MonthPassed]) = 1,[Gross Billings],[Gross Billings Budgeting])

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[pranit828]

Hi @aishak12 

Looks like you are trying to create a column.

But in the DAX formula you have used a measure which is underlined in red.

In the same formula try SELECTEDVALUE('table'[MonthPassed] instead.

[aishak12]

Can you help write out the formula, I currently have:

GrossBillingsIF = IF SELECTEDVALUE('table'[MonthPassed] = 1,[Gross Billings],[Gross Billings Budgeting])

which is saying "Selectedvalue" is incorrect