Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Please, i'm writting in a measure with a variable =MIN(YEAR). But, when i select a value in my Year slicer, the MIN will take my slicer value.
How can i do to get the MIN of my year, like using ALL() fonction.
regrads
Solved! Go to Solution.
Hi @nkasdali
You can use calculate to ignore the filter context.
Measure = CALCULATE(MIN(Date[Year]), ALL(Date))
Hi @nkasdali
You can use calculate to ignore the filter context.
Measure = CALCULATE(MIN(Date[Year]), ALL(Date))
Thanks 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |