Forum Discussion
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. Bu...
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.
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.
v-janeyg-msft: Many thanks for your help, solution works 🙂