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" || SELECT...
Need Help
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
)