Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
User | Count |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |