Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 [Maison]="Maison 2" THEN
IF NOT [Pièce maison] in ("Salon","Chambre",null) THEN 1
ELSE 0 END
END
Je n'ai rien trouvé sur internet..
Merci d'avance pour votre aide et bonne journée,
LD
Solved! Go to Solution.
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
)
Proud to be a Super User!
Paul on Linkedin.
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
)
Proud to be a Super User!
Paul on Linkedin.