topic Re: Syntax error by adding conditions in DAX Commands and Tips

Syntax error by adding conditions

Trodo7377 — Wed, 07 May 2025 11:42:35 GMT

I'm using this measure in PBI desktop which works fine:

m_lan= sumx(values('vAbc'[ProjectID]),calculate(DISTINCTCOUNT('vAbc'[ID])))))

But I need to add two conditions and tried to change m_lan as below but getting this error: The following syntax error occurred during parsing: Invalid token, Line 3, Offset 3, .
New measure(with line number):

1 m_lan = 2 var lan =CALCULATE( 3 DISTINCTCOUNT('vAbc'[ID]), 4 FILTER('vAbc', 5 'vAbc'[col1] <> "Hello" && 6 NOT(ISBLANK('vAbc'[col1])) 7 ) 8 ) 9 10 return SUMX(VALUES('vAbc'[ProjectID]), lan)

I've tried to rewrite the measure in many ways but still getting error or wrong result. How can I add those conditions to the original measure? or why I getting this error?

Re: Syntax error by adding conditions

Deku — Wed, 07 May 2025 12:14:38 GMT

m_lan =

SUMX(

VALUES('vAbc'[ProjectID]),

CALCULATE(

DISTINCTCOUNT('vAbc'[ID]),

FILTER(

All('vAbc'[col1]),

'vAbc'[col1] <> "Hello" &&

NOT iSBLANK( 'vAbc'[col1] )

)

Re: Syntax error by adding conditions

sjoerdvn — Wed, 07 May 2025 12:17:04 GMT

Have you tried something like this?

m_lan= CALCULATE( sumx(values('vAbc'[ProjectID]),calculate(DISTINCTCOUNT('vAbc'[ID]))) ,'vAbc'[col1] <> "Hello" ,NOT(ISBLANK('vAbc'[col1])) )

Re: Syntax error by adding conditions

Trodo7377 — Wed, 07 May 2025 12:30:13 GMT

Thank you for your suggestion. I changed measure but it shows the same value for all rows.

Re: Syntax error by adding conditions

BeaBF — Wed, 07 May 2025 12:34:39 GMT

Trodo7377 Try this:

m_lan =
SUMX(
VALUES('vAbc'[ProjectID]),
CALCULATE(
DISTINCTCOUNT('vAbc'[ID]),
'vAbc'[col1] <> "Hello",
NOT(ISBLANK('vAbc'[col1]))
)
)

It's a little different

BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

Re: Syntax error by adding conditions

Trodo7377 — Wed, 07 May 2025 12:35:58 GMT

Thank you, it worked!🙂

Re: Syntax error by adding conditions

sjoerdvn — Wed, 07 May 2025 13:16:31 GMT

yes. was wondering what the sumx was for. But you might have to share more on the data you have and the output you are trying to achieve here.