Forum Discussion

fjjpeeters1976's avatar
fjjpeeters1976
Helper III
1 year ago
Solved

ISFILTERED multiple values

  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 the...
  • johnt75's avatar
    johnt75
    1 year ago

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

grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

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!