Forum Discussion

EZiamslow's avatar
EZiamslow
Icon for Helper III rankHelper III
4 years ago
Solved

Target line based on product(s) selection in filter

Target =  Switch( true(), SELECTEDVALUE(Table[ProductName]) = "ProductA", 0.80, SELECTEDVALUE(Table[ProductName]) = "ProductB", 0.72, SELECTEDVALUE(Table[ProductName]) = "ProductC", 0.72 )   P...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    EZiamslow , Try like

     

    Target = if( countrows(allselected(Table[ProductName])) =1 , 
    Switch( true(),
    "ProductA" in allselected(Table[ProductName]) , 0.80,
    "ProductB" in allselected(Table[ProductName]) , 0.72,

    "ProductC" in allselected(Table[ProductName]) , 0.72
    ) , blank())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

EZiamslow , Try like

 

Target = if( countrows(allselected(Table[ProductName])) =1 , 
Switch( true(),
"ProductA" in allselected(Table[ProductName]) , 0.80,
"ProductB" in allselected(Table[ProductName]) , 0.72,

"ProductC" in allselected(Table[ProductName]) , 0.72
) , blank())

EZiamslow's avatar
EZiamslow
Icon for Helper III rankHelper III
4 years ago

amitchandak 

now, I can only select one ProductName at a time, even for the same target values.