CALCULATETABLE(Hotel; Hotel[HotelID] = VALUES(Competitor[HotelID]))

[spaxia]

Hello,

the subject contains what i want to do, is the an IN operator like TSQL?

thank you so much

[Eric_Zhang · Accepted solution]

@spaxia

To get a calculated table as the Subject, you can try

Table =
CALCULATETABLE (
    Hotel,
    FILTER (
        'Hotel',
        CONTAINS ( 'Com​petitor', 'Com​petitor'[HotelID], Hotel[HotelID] )
    )
)

or

Table =
FILTER (
    Hotel,
    CONTAINS ( 'Com​petitor', 'Com​petitor'[HotelID], Hotel[HotelID] )
)

[jahida]

CONTAINS should do it:

https://msdn.microsoft.com/en-us/library/gg492183.aspx