Forum Discussion

Trodo7377's avatar
Trodo7377
Frequent Visitor
1 year ago
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 ...
dax measure
  • Deku's avatar
    Deku
    1 year ago

    m_lan = 

    SUMX(

    VALUES('vAbc'[ProjectID]),

    CALCULATE(

    DISTINCTCOUNT('vAbc'[ID]),

    FILTER(

    All('vAbc'[col1]),

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

    NOT iSBLANK( 'vAbc'[col1] )

     )

     )

sjoerdvn's avatar
sjoerdvn
Solution Sage
1 year ago

Have you tried something like this?

m_lan= CALCULATE(
   sumx(values('vAbc'[ProjectID]),calculate(DISTINCTCOUNT('vAbc'[ID])))
   ,'vAbc'[col1] <> "Hello"
   ,NOT(ISBLANK('vAbc'[col1]))
)
Trodo7377's avatar
Trodo7377
Frequent Visitor
1 year ago

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