Convert from sql to dax

[OlegV]

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?

[AmiraBedh · Accepted solution]

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]

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]

Thank you for your reply.

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

And '""' becomes "" in DAX?

[AmiraBedh]

Check my answer 🙂