Forum Discussion

RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost Patron
6 years ago
Solved

Button with a measure

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 i...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
    RonaldvdH
    Icon for Post Patron rankPost Patron
    6 years ago

    amitchandak already tried that but unfortunately the error remains the same

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      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's avatar
        RonaldvdH
        Icon for Post Patron rankPost Patron
        6 years ago

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