Forum Discussion

NatalieB's avatar
NatalieB
New Member
4 years ago
Solved

Filtering a DAX/Measure by a selected range/two values

Hi All!   I've come as a sort of cry for help. I'm relatively new to PowerBi and all the complexities that come with DAX and measures. So I would appreciate some clarity on this problem I'm having....
  • amitchandak's avatar
    4 years ago

    NatalieB , Change these two and try

     

    YearMin = CALCULATE(MIN('DATA'[Year]), allselected() )
    YearMax = CALCULATE(MAX('DATA'[Year]), allselected())

  • NatalieB's avatar
    4 years ago

    Hello Amit!

     

    Thank you for the suggestion! I can't believe such a simple solution fixed my headache. Now I can continue on with the rest of the calculations! Hopefully nothing else pops up haha!