Dynamic Text on Button

[FaisalImam]

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 query that will follow these 4 conditions :

1. If nothing is selected , that is by default ,  text should be " Choose SOP to view"
2. If  one sop is select ,  text should be , "click to rediect "
3. If more than one is selected , text should be error
4. if one is selected but confluence path is empty , text should be " not available"

Please note : Confluence path is Web url.

I tried many dax , the problem I am facing is condiotion 2 and 3 are not working together. 

my dax :

Dynamic Button Text =

SWITCH(

TRUE(),

HASONEFILTER('New Sops'[Confluence path]) == BLANK() , "Empty",

HASONEVALUE('New Sops'[SOP description]) ,

"click",

"Select sop first"

)

[v-yanjiang-msft · Accepted solution]

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 · Accepted solution]

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.

[FaisalImam]

Can you please explain what is the Max function doing here - 

MAX ( 'New Sops'[Confluence path] ) = BLANK (),

[v-yanjiang-msft · Accepted solution]

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]

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.