Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello everyone, I am trying to use the calculate function with multiple filters. The goal is to calculate the Score of the highest Run per year.
It's currently hardcoded like this,
Score2020 = calculate([Score],Scores[year]=2020,Scores[run]=12) [results 0.62]
Score2021 = calculate([Score],Scores[year]=2021,Scores[run]=13) [results 0.63]
Score2022 = calculate([Score],Scores[year]=2022,Scores[run]=2) [results 0.18]
But I don't want to manually enter in the Run for Score2022 as the year progresses.
This is one of my many attempts, but I get errors every time.
If you need a separate measure for each year then you could try
Score 2022 = CALCULATE( MAX(Scores[Score]), Scores[Year] = 2022 )Or you could have it in 1 measure as
Best score = MAX( Scores[Score])If you use a slicer on Scores[Year], or put Scores[Year] into a visual then it will filter the results for each year separately.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |