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 page - even if no data exists. This is what i have done for the rework cost. by using a calculated & filtered measure. However how can i do this with a switch command? so they line up.

 

Seems either one or the other is correct. When i filter by additional field this works perfectly - wut when filtering by customer i just want the relevant data to show without my Rework target. Any help would be great

 

Rework Target = 
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,
isblank(selectedvalue('Index_Part Information'[Additional_Field_2])) , 0)

 

 

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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)

     

    • Jackbaz99's avatar
      Jackbaz99
      Helper I
      4 years ago

      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

       

  • 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.