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())