topic Re: ISFILTERED multiple values in DAX Commands and Tips

ISFILTERED multiple values

fjjpeeters1976 — Thu, 22 May 2025 11:46:04 GMT

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

Re: ISFILTERED multiple values

johnt75 — Thu, 22 May 2025 12:22:56 GMT

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

Re: ISFILTERED multiple values

grazitti_sapna — Fri, 23 May 2025 06:56:00 GMT

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!

Re: ISFILTERED multiple values

Anonymous — Fri, 23 May 2025 07:12:22 GMT

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