topic Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name. in DAX Commands and Tips

Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

Anonymous — Thu, 10 Apr 2025 08:06:04 GMT

Getting the error "Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name" with below query, please help Thanks!

EVALUATE

AG =CONCATENATEX(

FILTER(

'UAM',

'UAM'[AG] = MAX('UAM'[AG])

'UAM'[UG1],

";"

)

Data table example before aggregation:

UG1	GROUP_TYPE	AG	ITEM_TYPE	LOGIN	NAME	TYPE
A-1	UG	AM	AG	1234	Ana	1
A-1	UG	AM1	AG	12345	Ben	1
A-2	UG	AMF	AG	123456	Dan	1

Databel table after aggregation:
UG AG
A-1 AM;AM1
A-2 AMF

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

bhanu_gautam — Thu, 10 Apr 2025 08:25:05 GMT

Anonymous , Use

dax
AG =
CONCATENATEX(
FILTER(
'UAM',
'UAM'[AG] = MAXX(ALL('UAM'), 'UAM'[AG])
),
'UAM'[UG1],
";"
)

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

Deku — Thu, 10 Apr 2025 08:30:06 GMT

When using EVALUATE the output needs to be a table

You could something like

Evaluate

Define AG =CONCATENATEX(

FILTER(

'UAM',

'UAM'[AG] = MAX('UAM'[AG])

'UAM'[UG1],

";"

)

{Ag}

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

Anonymous — Thu, 10 Apr 2025 08:35:25 GMT

Thanks!

Getting the below:
Query (2, 1) The syntax for 'AG' is incorrect. (dax
AG =
CONCATENATEX(
FILTER(
'UAM',
'UAM'[AG] = MAXX(ALL('UAM'), 'UAM'[AG])
),
'UAM'[UG1],
";"
)).

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

v-kpoloju-msft — Thu, 10 Apr 2025 10:30:28 GMT

Hi Anonymous,
Thank you for reaching out to the Microsoft fabric community forum. Thank you Deku, bhanu_gautam, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.

Dax Measure for UAM Aggregated:
UAM_Aggregated =

ADDCOLUMNS(

SUMMARIZE('UAM', 'UAM'[UG1]),

"AG_Combined", CONCATENATEX(

FILTER('UAM', 'UAM'[UG1] = EARLIER('UAM'[UG1])),

'UAM'[AG],

";"

)

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

Anonymous — Fri, 11 Apr 2025 01:14:34 GMT

Thank you for the help , I am trying to get DISTINCT AG after CONCETENATE as right now the output will be as below: Tried to add in the DISTINCT function before FILTER but no luck, any clue? thanks

UG AG
A-1 AM;AM;AM1
A-2 AMF;AMF

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

v-kpoloju-msft — Fri, 11 Apr 2025 04:10:38 GMT

Hi Anonymous,

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.

Dax Measure:

AG_Concat_Duplicates =

CONCATENATEX(

FILTER(AGTable, AGTable[UG] = MAX(AGTable[UG])),

AGTable[AG],

";"

)

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

v-kpoloju-msft — Sun, 13 Apr 2025 16:59:26 GMT

Hi Anonymous,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

v-kpoloju-msft — Wed, 16 Apr 2025 14:05:47 GMT

Hi Anonymous,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Re: Query (2, 1) Failed to resolve name 'AG'. It is not a valid table, variable, or function name.

v-kpoloju-msft — Sun, 20 Apr 2025 05:06:37 GMT

Hi Anonymous,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.