Forum Discussion
Solved
DAX
Hi, I need to write a measure that will be calculated on the chart only for the smaller of the selected years. That is, if I select 2023 and 2024 on the slicer, I only want to see the value for 2...
yes you are right. The issue was due to an oversight on my part. you should write it as follows...
var min_year = calculate( min ('date' [year]) , allselected ('date' [year]))
Selva-Salimi
Solution Sage
Solution Sage
so you should write it as follows:
var min_year = calculate( min ('date' [year]) , allselected ('date' , 'date' [year]))
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
Still doesn't work:(
- Selva-Salimi
Yes, for this second option I got "Multiple arguments are not allowed in the ALLSELECTED function when the first argument is a table reference."