Dynamic Text on Button

Hi FaisalImam ,

According to your description, here's my solution, create a measure.

Measure =
IF (
    ISFILTERED ( 'New Sops'[SOP description] ),
    IF (
        COUNTROWS ( VALUES ( 'New Sops'[SOP description] ) ) > 1,
        "Error",
        IF (
            MAX ( 'New Sops'[Confluence path] ) = BLANK (),
            "Not available",
            "click to rediect "
        )
    ),
    " Choose SOP to view"
)

Get the correct result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

Hi FaisalImam ，

In a measure, MAX usually used to return the current row, here it can return the correspongding [Confluence path]  to the selected [SOP description].

Best Regards,
Community Support Team _ kalyj