Forum Discussion

FaisalImam's avatar
FaisalImam
Icon for Helper I rankHelper I
3 years ago
Solved

Dynamic Text on Button

Hi Team,  Need help with DAX  for dynamic text on Button.   So we have a table  gear id  sop   confluence path 1 batch https://.... 4 rfb   8 job  https://....   I want a...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

     

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

Something like the following may solve your issue

 

Dynamic Button Text =
var _numFilters =
IF(
    ISFILTERED('Table'[sop]),
    COUNTROWS(FILTERS('Table'[sop])),
    0
)
Return
SWITCH(
    TRUE(),
    _numFilters > 1, "Select only one SOP",
    _numFilters = 1 && SELECTEDVALUE('Table'[Confluence path]) = "", "Unavailable",
    _numFilters = 1, "Click to Redirect",
    "Choose SOP to View"
)
 
As a reminder, the items in your switch function are evaluted in the order they occur.
 
Hope this gets you going in the right direction.