Dax SelectedValue With And Condition

Question

Hi there,&nbsp;I successed to form a filter with selectedvalue.However for the screen cap below, the Article 301514200 didn't exist in "Biodegradable" but exist in "Active". The outcome I wish is that the sales record won't appear once I selected both "Active" and "Biodegradable".&nbsp;SelectedNetSales(AND) = VAR SRecordGRP =&nbsp; &nbsp; ALLSELECTED ( 'Assortment Ori'[Record_Group] )VAR SArt =&nbsp; &nbsp; ALLSELECTED ( 'Assortment Ori'[Article_Code] )VAR SRecord =&nbsp; &nbsp; ALLSELECTED ( &nbsp;'Assortment Ori'[Record] ) VAR SDate =&nbsp; &nbsp; ALLSELECTED ( 'Assortment Ori'[YearMonth] ) RETURN&nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; SUMX ( Sales, VALUE ( Sales[NET_SALES] ) ),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Assortment Ori',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Assortment Ori'[Record_Group] IN SRecordGRP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp;&amp; 'Assortment Ori'[Record] IN SRecord&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp;&amp; 'Assortment Ori'[YearMonth] IN SDate&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )Thank you for your help.Sammy Chu

johnt75 · Answer

There's a good article and video on using AND logic for slicers at&nbsp;https://www.sqlbi.com/tv/apply-and-logic-to-multiple-selection-in-dax-slicer/&nbsp;

sammy02hk · Answer

Thank you for your help. Let have a look.

Forum Discussion

Dax SelectedValue With And Condition

2 Replies

Related content

Selectedvalue

IF and SELECTEDVALUE Condition

Selectedvalue with AND condition

IF and SELECTEDVALUE with multiple conditions

selectedvalue & switch