topic Re: Selectedvalue dax to work for multiple options selected in filter in DAX Commands and Tips

Selectedvalue dax to work for multiple options selected in filter

han_rj — Wed, 17 Jul 2024 17:29:13 GMT

I want to write a dax to calculate discount to apply based on slicer selection [product slicer].
Example when Chair and Sofa are purchases I would like to apply a 12% discount but single selection using selectedvalues works but applying condition on multiple values obtained from the slicer does not.

Re: Selectedvalue dax to work for multiple options selected in filter

Greg_Deckler — Wed, 17 Jul 2024 19:45:46 GMT

han_rj Correct, SELECTEDVALUE returns BLANK if there is more than one row returned. You can just grab the values (DISTINCT) in the slicer and use the IN operator.

Re: Selectedvalue dax to work for multiple options selected in filter

han_rj — Thu, 18 Jul 2024 04:42:38 GMT

Greg_Deckler , thank you for responding,Tried using distinct in a calculated table, I am missing something please can you correct me.

Re: Selectedvalue dax to work for multiple options selected in filter

Anonymous — Thu, 18 Jul 2024 06:27:20 GMT

Hi, han_rj

You can try the following methods.

Measure:

Measure = VAR _selectedprod = ALLSELECTED ( 'Table'[Product] ) VAR _IntersectCount = COUNTROWS ( INTERSECT ( _selectedprod, { "Chair", "Sofa" } ) ) VAR _List1Count = COUNTROWS ( _selectedprod ) VAR _result = SWITCH ( TRUE (), SELECTEDVALUE('Table'[Product]) = "Chair", 10, SELECTEDVALUE('Table'[Product]) = "Sofa", 20, SELECTEDVALUE('Table'[Product]) = "Table", 15, _IntersectCount =_List1Count, 12, 20 ) RETURN _result

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

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

Re: Selectedvalue dax to work for multiple options selected in filter

han_rj — Thu, 18 Jul 2024 06:45:14 GMT

Hi Anonymous , Thank You for checking , The value should be 12 when chair and sofa is selected

Re: Selectedvalue dax to work for multiple options selected in filter

Anonymous — Thu, 18 Jul 2024 07:05:26 GMT

Hi, han_rj

You can try the following methods.

Measure 2 = VAR _selectedprod = ALLSELECTED ( 'Table'[Product] ) VAR _IntersectCount = COUNTROWS ( INTERSECT ( _selectedprod, { "Chair", "Sofa" } ) ) VAR _List1Count = COUNTROWS ( _selectedprod ) VAR _result = IF( _IntersectCount =_List1Count && _List1Count > 1,12, SWITCH ( TRUE (), SELECTEDVALUE('Table'[Product]) = "Chair", 10, SELECTEDVALUE('Table'[Product]) = "Sofa", 20, SELECTEDVALUE('Table'[Product]) = "Table", 15, 20 )) RETURN _result

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

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

Re: Selectedvalue dax to work for multiple options selected in filter

Greg_Deckler — Thu, 18 Jul 2024 14:17:46 GMT

han_rj Should be something like:

VAR __selected = DISTINCT('Table'[Product])

VAR __result = SWITCH( TRUE(), "Chair" IN __selected, 10, ...

Re: Selectedvalue dax to work for multiple options selected in filter

han_rj — Tue, 23 Jul 2024 14:10:38 GMT

Thank You , this helped me