Forum Discussion

smtiwari's avatar
smtiwari
Helper I
5 years ago
Solved

DrillThrough Button with single value data

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?
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    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.

3 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    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.

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    5 years ago

    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.