Forum Discussion
Syntax error by adding conditions
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?
m_lan =
SUMX(
VALUES('vAbc'[ProjectID]),
CALCULATE(
DISTINCTCOUNT('vAbc'[ID]),
FILTER(
All('vAbc'[col1]),
'vAbc'[col1] <> "Hello" &&
NOT iSBLANK( 'vAbc'[col1] )
)
)
6 Replies
Have you tried something like this?
m_lan= CALCULATE( sumx(values('vAbc'[ProjectID]),calculate(DISTINCTCOUNT('vAbc'[ID]))) ,'vAbc'[col1] <> "Hello" ,NOT(ISBLANK('vAbc'[col1])) )m_lan =
SUMX(
VALUES('vAbc'[ProjectID]),
CALCULATE(
DISTINCTCOUNT('vAbc'[ID]),
FILTER(
All('vAbc'[col1]),
'vAbc'[col1] <> "Hello" &&
NOT iSBLANK( 'vAbc'[col1] )
)
)
Thank you, it worked!🙂
