Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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 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

  • v-zhangti's avatar
    v-zhangti
    Community 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.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    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.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

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