Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Does not take segmentation value with selectedvalue

Hello someone can help me because I don't have the if correctly. According to the dax, it should show in the column Title with year, Forecast 2023 and instead I only get For...
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

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))

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.