Forum Discussion

aishak12's avatar
aishak12
Helper IV
5 years ago
Solved

Single value for column error

Does anyone know what this error details and how to resolve this.    
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hiaishak12,

     

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    aishak12
    Helper IV
    5 years ago

    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