Forum Discussion
Anonymous
3 years agoNot applicable
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...
- 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 )
PaulDBrown
Community Champion
3 years agoWith 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
)