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
Syndicate_Admin
Administrator
Administrator

Does not take segmentation value with selectedvalue

Hello

someone can help me because I don't have the if correctly.

apenaranda_0-1675762212180.png

apenaranda_1-1675762307873.png

According to the dax, it should show in the column Title with year, Forecast 2023 and instead I only get Forecast. It does not take into account the value selected in the segmentation. This same dax code has always worked for me.

Thank you.

4 REPLIES 4
Syndicate_Admin
Administrator
Administrator

Do I understand that there is no way to condition the text of the rows of an array?

apenaranda_0-1679998368749.png

Syndicate_Admin
Administrator
Administrator

Thank you very much, that's what I wanted. Also, as I commented in the previous post, the way I did it has worked for me other times, I do not understand why not now.

Anyway, thank you very much.

v-zhangti
Community Support
Community Support

Hi, @Syndicate_Admin 

 

You can try the following methods.

Measure = Var _ANY=SELECTEDVALUE('Year'[Year])
Return
IF(SELECTEDVALUE('Table'[Type])="A",CONCATENATE(SELECTEDVALUE('Table'[Type]),_ANY))

vzhangti_0-1675840364596.pngvzhangti_1-1675840372487.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Syndicate_Admin , You can not use selected value in new column or table

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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