Forum Discussion
Solved
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 ...
m_lan =
SUMX(
VALUES('vAbc'[ProjectID]),
CALCULATE(
DISTINCTCOUNT('vAbc'[ID]),
FILTER(
All('vAbc'[col1]),
'vAbc'[col1] <> "Hello" &&
NOT iSBLANK( 'vAbc'[col1] )
)
)
Thank you for your suggestion. I changed measure but it shows the same value for all rows.
