Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to use a different measure based on the year. If Year = max(year) then use measure 1 else use measure 2.
In the example below measure 3 uses measure 1 for Max(Year) and measure 2 for the rest of the years.
This dax isn't working for me for some reason. It only returns Measure 1
Solved! Go to Solution.
@BIBRO , In such case the selected value has come from an independent year table
if(SELECTEDVALUE(year[year]) = MAX(table[year]),[measure 1],[measure 2])
Measure =
var _max =maxx(allselected(year), year[year])
return
if(_max = MAX(table[year]),[measure 1],[measure 2])
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
@BIBRO , In such case the selected value has come from an independent year table
if(SELECTEDVALUE(year[year]) = MAX(table[year]),[measure 1],[measure 2])
Measure =
var _max =maxx(allselected(year), year[year])
return
if(_max = MAX(table[year]),[measure 1],[measure 2])
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |