DrillThrough Button with single value data

[smtiwari]

Hi All,

I am stuck with a problem when using drill through buttons . I am using below DAX for my drillthrough-button , its disabled initially and gets enabled upon selection on a data point.

Button = IF(

             SELECTEDVALUE('Table'[Data],0)==0,"Disabled", SELECTEDVALUE('Table'[Data]))

This works fine when multiple values are available for the visual, however it doesnt work when we

have single value on the visual (due to lack of data)

I want this to show the disabled text instead of Company A:

What am I missing here?

[v-janeyg-msft · Accepted solution]

Hi, @smtiwari 

It’s my pleasure to answer for you.

According your description, I think you can modify your measure to meet your requirement..

Like this:

Button =
IF (
    ISFILTERED ( Table1[data] ),
    IF (
        SELECTEDVALUE ( 'Table1'[data], 0 ) == 0,
        "Disabled",
        SELECTEDVALUE ( Table1[data] )
    ),
    "Disabled"
)

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

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

[smtiwari]

@v-janeyg-msft: Many thanks for your help, solution works 🙂

[mwegener]

Hi @smtiwari ,

SELECTEDVALUE returns the value when there’s only one value in the specified column, otherwise returns the alternate result.

So you only interpret the result data and not the filter/action itself.

I do not know any other solution, but it works as expected.