ISFILTERED multiple values

[fjjpeeters1976]

I have a database which has different scenarios. I want to give the user the option to compare one scenario vs another scenario as well as the option to select the months, quarters, years that they want to see. For this I created two stand alone tables that gives me the years, half year, quarter and month to select from (using hierarchy filter). I now want to use the selectedvalues as an input in my dax formular as following: calculate(expression, calender IN selectedvalue()).

So my first approach was to use the isfiltered function to see if months, quarters, half year or year is selected. However so far I only managed to retrieve the value if only one month was selected, for example Jan. But I would like to have the option that they can choose multiple years. Any hints or tips?

see below

[v-nmadadi-msft]

Hi @fjjpeeters1976 ,
Thanks for reaching out to the Microsoft fabric community forum.

Thank you to @johnt75  for their valuable suggestion.

Here is a previous discussion that happened in the forum where the query got resolved by using values as well, please check it out as I think it will be helpful to know how exactly to integrate VALUES into your DAX formula
Solved: Multiple selection from slicer with multiple value... - Microsoft Fabric Community

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[grazitti_sapna]

Hi @fjjpeeters1976 

If you want to select multiple values (months, quarters, years, etc.), and filter a measure accordingly, you need to use Values() instead of SelectedValue(), and apply it in a CALCULATE filter context.

MyMeasure :=
CALCULATE(
    [YourBaseMeasure],
    'Calendar'[Period] IN VALUES('PeriodSelector'[Period])
)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[johnt75 · Accepted solution]

Instead of SELECTEDVALUE use VALUES. That will return multiple rows if more than 1 option is chosen.