Forum Discussion

Lazarosper's avatar
Lazarosper
Regular Visitor
2 years ago

What is wrong with my DAX Measure?

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?

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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
)