Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Fonction IF et NOT CONTAINS

Bonjour à tous,    Je cherche à reproduire cette formule en formule dax svp:   IF [Maison]='Maison 1' THEN       IF NOT  [Pièce maison] in ('Cuisine',"SDB",null) THEN 1 ELSE 0 END ELSEIF [Mais...
  • PaulDBrown's avatar
    3 years ago

    With this sample table

    You can flag the items using a measure as follows:

    Not in list =
    VAR _Values =
        VALUES ( 'Table'[Item] )
    VAR _M1 = { "Bed", "Chair", "Door" }
    VAR _M2 = { "Blanket", "Curtain", "Sheet" }
    RETURN
        SWITCH (
            TRUE (),
            AND (
                SELECTEDVALUE ( 'Table'[House] ) = "Maison 1",
                SELECTEDVALUE ( 'Table'[Item] )
                    IN EXCEPT ( _Values, _M1 ) //checks if item is in table excluding the values listed in _M1
            ), 1,
            AND (
                SELECTEDVALUE ( 'Table'[House] ) = "Maison 2",
                SELECTEDVALUE ( 'Table'[Item] )
                    IN EXCEPT ( _Values, _M2 ) //checks if item is in table excluding the values listed in _M2
            ), 1,
            0
        )