Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |