Button with a measure

[RonaldvdH]

Guys,

i was checking out the powerbi release video for match 2020 and saw this feature (maybe it was always there but i just saw it :))

The showed me that i can use a measure in a button which is very cool but the formula they displayed doesn't work for me

String_for_button = if(SELECTEDVALUE('Adres Taken'[AP gebied]; 0); == 0) ; "See product details";"See details for "&SELECTEDVALUE('Adres Taken'[AP gebied]))

The red part returns a syntax error but that is strange cause ive copied it directly from the video so what am i doing wrong ?

[Anonymous · Accepted solution]

HI @RonaldvdH,

You can try to use the following measure formula if it meets for your requirement:

String_for_button =
IF (
    SELECTEDVALUE ( 'Adres Taken'[AP gebied] ) <> BLANK ();
    "See product details";
    "See details for "
        & CONCATENATEX ( VALUES ( 'Adres Taken'[AP gebied] ); [AP gebied]; "," )
)

Regards,

Xiaoxin Sheng

[RonaldvdH]

@Anonymous your solution did the trick it's just that i think ive marked the wrong post as a solution :):)

[amitchandak]

Try one with =

String_for_button = if(SELECTEDVALUE('Adres Taken'[AP gebied]; 0); = 0) ; "See product details";"See details for "&SELECTEDVALUE('Adres Taken'[AP gebied]))

[RonaldvdH]

@amitchandak already tried that but unfortunately the error remains the same

[amitchandak]

@RonaldvdH ,I tried it. I think if is closing at wrong place.

Measure 5 = if(SELECTEDVALUE('Item'[Brand],0)==0,"See All brand", "See value for brand"&SELECTEDVALUE('Item'[Brand]))

[RonaldvdH]

@amitchandak still the same result, ive tried changing the ( or ) but the problem is stil the syntax of the ==