Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello guys so this is my Dax code
testin1 =
IF (
(
SELECTEDVALUE('Campaign Lookup'[Campaign]) IN { "A", "B", "C" }
&&
(
SELECTEDVALUE('Campaign Lookup'[Placement]) = "DEMANDGEN"
||
SELECTEDVALUE('Campaign Lookup'[Placement]) = "PMAX"
||
(SELECTEDVALUE('Campaign Lookup'[Placement]) = "DEMANDGEN" && SELECTEDVALUE('Campaign Lookup'[Placement]) = "PMAX")
)
),
DIVIDE([Total Cost], [Total Budget Cost]),
0
)
What values i would like to get is that when the user select from the campaign slicer any of this 3 values AND from the placement slicer any of this 2 values to get 0 ,the code works fine when it comes if the user select 1 of the 2 values from the placement slicer but if they select both it doesnt return 0 as i would expect.Why is that?
SELECTEDVALUE is exactly ONE value. You could use VALUES() or you could refactor your code.
testin1 =
IF (SELECTEDVALUE ( 'Campaign Lookup'[Campaign] ) IN { "A", "B", "C" }
&& SELECTEDVALUE ( 'Campaign Lookup'[Placement] ) IN {"DEMANDGEN", "PMAX"},
DIVIDE ( [Total Cost], [Total Budget Cost] ),
0
)