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.

3 Replies

  • 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
  • Anonymous's avatar
    Anonymous
    Not applicable
    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.