Forum Discussion
Losing Filtered Dates when using SWITCH
Hi, really struggling with this - but think im nearly there. Code im using is below - and picture is after that. I am trying to get the newly created target line to follow the filtered dates onthe...
Jackbaz99 , This Does not seem to have the impact on customer filter . But when nothing is selected you can try like
Check first line , isfiltered
Rework Target =
SWITCH( TRUE(),
not(isfiltered('Index_Part Information'[Additional_Field_2]), 0,
"A P" in allselected('Index_Part Information'[Additional_Field_2]) , 1000 ,
"AP Jet" in allselected('Index_Part Information'[Additional_Field_2]) , 150 ,
"SSO" in allselected('Index_Part Information'[Additional_Field_2]) , 500 ,
"LMT" in allselected('Index_Part Information'[Additional_Field_2]) , 500,
isblank(selectedvalue('Index_Part Information'[Additional_Field_2])) , 0)
amitchandak it seems to not work - says the () expression is not supported. Otherwise i think this could work - when customer is selected it just stays blank which is what i need. Or is there a way i can put if any customer selected then 0 or something