Calculation error in measure "": A function 'FILTER' has been used in a True/False expression

[Anonymous]

Hi everyone,

I have a measure which creates following error: Calculation error in measure "": A function 'FILTER' has been used in a True/False expression that is used as a table filter expression.

The measure:

CALCULATE (
                DISTINCTCOUNT ( Sales[CustomerID] ),
                OR (
                    FILTER ( Countries, Countries[CountryID] = "VS" ),
                    FILTER (
                        'Product',
                        ( 'Product'[System] = "AJ98"
                            || 'Product'[System] = "AJ1032" )
                            && 'Product'[ProductCode] <> "1W"
                            && 'Product'[ProductCode] <> "2W"
                            && 'Product'[ProductCode] <> "1E"
                            && 'Product'[ProductCode] <> "1C"
                            && 'Product'[ProductCode] <> "5B"
                            && 'Product'[ProductCode] <> "9F"
                            && 'Product'[ProductCode] <> "2G"
                    )
                )
            )

So I want the measure be filtered or with the CountryID = "VS" or the other part.

When I use the filters separate, it works.

Luuk

[technolog]

Here's how you can rewrite your measure:

FilteredCustomerCount =
VAR CountryCondition =
COUNTROWS(
FILTER(
Countries,
Countries[CountryID] = "VS"
)
) > 0

VAR ProductCondition =
COUNTROWS(
FILTER(
'Product',
(
'Product'[System] = "AJ98"
|| 'Product'[System] = "AJ1032"
)
&& 'Product'[ProductCode] <> "1W"
&& 'Product'[ProductCode] <> "2W"
&& 'Product'[ProductCode] <> "1E"
&& 'Product'[ProductCode] <> "1C"
&& 'Product'[ProductCode] <> "5B"
&& 'Product'[ProductCode] <> "9F"
&& 'Product'[ProductCode] <> "2G"
)
) > 0

RETURN
CALCULATE(
DISTINCTCOUNT(Sales[CustomerID]),
CountryCondition || ProductCondition
)