Direct Query - OR() function don't exist

[Anonymous]

Hello,

I'm trying to do a simple OR() function using DIrect Query mode but it's not their. I found on the web that if I select "Allow unrestricted measures in DirectQuery mode." in Options -> Direct Query, this should resolve my problem, but this check box don't exist anymore.

Any ideas how to workaround this issue?

[TomMartens]

Hey, 

you can use this

|| (two pipe signs) instead of OR and

&& instead of AND

This measure

Measure = 
CALCULATE(
    SUM('Table1'[value])
    , FILTER(
        'Table1'
        , 'Table1'[color] = "red" || 'Table1'[color] = "yellow"
    )
)

creates this:

Hopefully this is what you are looking for.

Regards,

Tom