Forum Discussion

ian11001's avatar
ian11001
Frequent Visitor
4 years ago
Solved

Operator or expression '()' is not supported in this context

Hi Team,

Good day!

 

I'm currently having this error with my measure not sure what is the proper syntax. 😞

 

Department All = If (VALUES('asset_inventory asset'[Alt Department]) <> "null", VALUES('asset_inventory asset'[Alt Department]), VALUES('bhr_collection employee'[department])
 
Thank you in advance!

 

Custom Visuals
Dashboards
Data Modeling
  • MahyarTF's avatar
    MahyarTF
    4 years ago

    Hi,

    You need the ')' at the end of your code. 

    It is not closed properly. If you did, use the below code instead :

    Department All = If (SELECTEDVALUE('asset_inventory asset'[Alt Department]) <> "",
                         SELECTEDVALUE('asset_inventory asset'[Alt Department]),
                         SELECTEDVALUE('asset_inventory asset'[Alt Department])
                        )
    Appreciate your Kudos
  • MahyarTF's avatar
    MahyarTF
    4 years ago

    Hi,

    I have another suggestion :

    1- in Power Query, Merge these tables based on the 'Name', and bring the names and Alt Department from Table1 and Department from Table2

    2- Add a custom column and use below M query :

    if [Alt Department] <> "" and Text.Upper([Alt Department]) <> Text.Upper("null")
    then [Alt Department]
    else [Sheet143.department]

    3- then use the created column in your visual :

     

8 Replies

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi,

    You need the ')' at the end of your code. 

    It is not closed properly. If you did, use the below code instead :

    Department All = If (SELECTEDVALUE('asset_inventory asset'[Alt Department]) <> "",
                         SELECTEDVALUE('asset_inventory asset'[Alt Department]),
                         SELECTEDVALUE('asset_inventory asset'[Alt Department])
                        )
    Appreciate your Kudos
  • HoangHugo's avatar
    HoangHugo
    Icon for Solution Specialist rankSolution Specialist
    4 years ago

    Hi,

    I don't know what is your purpose with dax. the function VALUES return a table with unique value column.

    • ian11001's avatar
      ian11001
      Frequent Visitor
      4 years ago

      Hi HoangHugo

      Sorry forgot to state my goal

       

      Basically I want to combine the value of  ('asset_inventory asset'[Alt Department]) and ('bhr_collection employee'[department]) in to one column,  in the ('asset_inventory asset'[Alt Department]) there are null values that I want to replace it with the value in the ('bhr_collection employee'[department]).


      Not sure how to do it really

  • ian11001's avatar
    ian11001
    Frequent Visitor
    4 years ago

    Thank you MahyarTF 

     

    IT worked now the syntax but it didnt show the result I was expecting.

    Basically I want to combine the value of  ('asset_inventory asset'[Alt Department]) and ('bhr_collection employee'[department]) in to one column,  in the ('asset_inventory asset'[Alt Department]) there are null values that I want to replace it with the value in the ('bhr_collection employee'[department]).

     

    • MahyarTF's avatar
      MahyarTF
      Icon for Memorable Member rankMemorable Member
      4 years ago

      Hi,

      Would you please share sample data here ?

      • ian11001's avatar
        ian11001
        Frequent Visitor
        4 years ago

        Hi MahyarTF ,

         

        I have two tables, table1 and table2  some of the details on the Alt Department column has no data, that's why I want to create a new column based from the combination of  Alt Department from Table1 and Department from Table2 to produce the column of All Department. Already stablished the relationship of the two tables, only the combining of two columns I'm trying to solve.

        Please let me know if this is possible, thank you!