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

[ian11001]

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!

[MahyarTF · Accepted solution]

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

[ian11001]

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]

Hi,

Would you please share sample data here ?

[ian11001]

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!

[MahyarTF · Accepted solution]

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 :

[ian11001]

Thank you so much, it worked! 🙂

[HoangHugo]

Hi,

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

[ian11001]

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

[MahyarTF · Accepted solution]

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