Selectedvalue dax to work for multiple options selected in filter

[han_rj]

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.

[Anonymous]

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.

[han_rj]

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

[Anonymous · Accepted solution]

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.

[han_rj]

Thank You , this helped me

[Greg_Deckler]

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

[han_rj]

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

[Greg_Deckler]

@han_rj Should be something like:

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

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