Forum Discussion

OlegV's avatar
OlegV
Helper III
2 years ago
Solved

Convert from sql to dax

Hi,

In SQL server there are two strings in the where clause:

'" "' (single double space double single)

'""' (single double double single)

 

Select ...

From ...

Where ColumnA <> '" "' and ColumnA <> '""'

 

How can I recreate where statement in DAX?

 

 

 

Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    Here's how you can recreate your SQL WHERE clause in DAX:

    FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)

    Or, if you are creating a measure or a calculated column, you might use an expression like this:

    MeasureName = CALCULATE (
[YourCalculation],
FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)
)

4 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

    Here's how you can recreate your SQL WHERE clause in DAX:

    FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)

    Or, if you are creating a measure or a calculated column, you might use an expression like this:

    MeasureName = CALCULATE (
[YourCalculation],
FILTER (
TableName,
NOT (ColumnA = ' " ' ) && NOT (ColumnA = '""')
)
)
  • ftgpdx's avatar
    ftgpdx
    Frequent Visitor
    2 years ago

    Assuming this is for a new measure within the report, I've generally solved this with a CALCULATE and double & for the AND. You could do something like: 

     

     

    CALCULATE(
    SUM( 'Table'[Column] ),
    (NOT( 'Table'[Column A] = " ")  &&  NOT( 'Table'[Column A] = "")  )
)

     

     

    • OlegV's avatar
      OlegV
      Helper III
      2 years ago

      Thank you for your reply.

       

      Do you think that sql server string '" "' becomes " " in DAX.

      And '""' becomes "" in DAX?