Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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 = '""')
)
)
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 = '""')
)
)
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] = "") )
)
Thank you for your reply.
Do you think that sql server string '" "' becomes " " in DAX.
And '""' becomes "" in DAX?
Check my answer 🙂
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |