Using multiple values from slicer in CALCULATE DAX expression

cwfmoore — Fri, 27 May 2022 10:32:42 GMT

Hello,

I have a PowerBI dashboard which has a date table connected to a table of student applications. I also have a slicer of academic years.

I would like to be able to capture the multiple selections made on the slicer to be used in further DAX expressions in a CALCULATE statement.

For example: (psuedo code)

VAR selected_years = SELECTEDVALUE('Date'[Academic Years])

VAR calc =
CALCULATE(COUNT('Student Applications'[Id])

FILTER(

'Date',

'Date'[Academic Years] IN selected_years

)

RETURN calc

Re: Using multiple values from slicer in CALCULATE DAX expression

SpartaBI — Fri, 27 May 2022 11:54:20 GMT

cwfmoore

VAR selected_years = VALUES('Date'[Academic Years])

VAR calc =
CALCULATE(COUNT('Student Applications'[Id])

FILTER(

'Date',

'Date'[Academic Years] IN selected_years

)

RETURN calc

If you do SELECTEDVALUE it will only return that value if there is one and for multiple choices will default to blank.
In general , if you just want to capture the years selcted then you don't need to do anything cause they are already taken by default in the filter context on measures that acts on related table.
So, for instance, this would have given you the same result:
COUNT('Student Applications'[Id])

btw, also this would give you the same result per yoor pseudo code:

VAR selected_years = VALUES('Date'[Academic Years])

VAR calc =
CALCULATE(
COUNT('Student Applications'[Id]),

selected_years

)

RETURN calc

Showcase Report – Contoso By SpartaBI

topic Using multiple values from slicer in CALCULATE DAX expression in DAX Commands and Tips

Using multiple values from slicer in CALCULATE DAX expression

Re: Using multiple values from slicer in CALCULATE DAX expression