How to filter a measure by multiple values

[ohojames]

Hi folks,

I'd like to get multiple selected values from slicer  to apply in a measure. 

I'm now using a SELECTEDVALUE() which is not working for multiple values, please suggest on this issue.

attractionSummary = 
var visualType = SELECTEDVALUE('A'[data_type])   // how to get multiple selected values from slicer
RETURN
    CALCULATE(SUM('A'[date_publish_all]),
        FILTER(ALL('A'), 'A'[datekey] = MAX('A'[datekey])
                && 'A'[actor_id]=1
                    &&'A'[data_type]=visualType))

Thank you in advance

[MFelix · Accepted solution]

Hi @ohojames,

To what I can see from your measure all the filters are made based on the same table so the filter option is not needed to have it based on your filter. When you have a slicer based on a table all the information is filter from your measures and visuals accordingly so by default you are already making selected values.

Based on your measure and if you have a slicer from table 1 for datatype & datekey your measure should look something like this:

attractionSummary =
VAR datekey =
    MAX ( ALL ( 'A'[datekey] ) )
RETURN
    CALCULATE (
        SUM ( 'A'[date_publish_all] ),
        'A'[datekey] = datekey
            && 'A'[actor_id] = 1
    )

No need to place the data_type in your filter since you are getting the only selected values from your filter to make the calculations

Can you share some data, model setup and expected result.

Regards,

MFelix