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.

    • BeaBF's avatar
      BeaBF
      Super User
      1 year ago

      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!

    • sjoerdvn's avatar
      sjoerdvn
      Solution Sage
      1 year ago

      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.