Forum Discussion
NatalieB
4 years agoNew Member
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....
- 4 years ago
NatalieB , Change these two and try
YearMin = CALCULATE(MIN('DATA'[Year]), allselected() )
YearMax = CALCULATE(MAX('DATA'[Year]), allselected()) - 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!
NatalieB
4 years agoNew Member
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!