topic Re: Losing Filtered Dates when using SWITCH in DAX Commands and Tips

Losing Filtered Dates when using SWITCH

Jackbaz99 — Thu, 17 Feb 2022 15:35:57 GMT

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)

Re: Losing Filtered Dates when using SWITCH

amitchandak — Thu, 17 Feb 2022 17:15:30 GMT

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)

Re: Losing Filtered Dates when using SWITCH

Jackbaz99 — Thu, 17 Feb 2022 18:55:32 GMT

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

Re: Losing Filtered Dates when using SWITCH

Jackbaz99 — Mon, 21 Feb 2022 08:46:05 GMT

amitchandak any help with the above please

Re: Losing Filtered Dates when using SWITCH

Anonymous — Fri, 25 Feb 2022 01:36:01 GMT

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.