Forum Discussion

Jackbaz99's avatar
Jackbaz99
Helper I
4 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Jackbaz99 ,

You can change dax to the following form

Rework Target =
If(
ISFILTERED('Index_Part Information'[Additional_Field_2])=false(),0,
SWITCH( TRUE(),
"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,0
))

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.