Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
BIBRO
Frequent Visitor

Switch measures based on column value

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.

BIBRO_0-1660080262804.png

This dax isn't working for me for some reason. It only returns Measure 1

Measure 3 =
if(SELECTEDVALUE(table[year]) = MAX(table[year]),[measure 1],[measure 2])

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.