Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
@v-shex-msft your solution did the trick it's just that i think ive marked the wrong post as a solution :):)
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 ,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]))
@amitchandak still the same result, ive tried changing the ( or ) but the problem is stil the syntax of the ==
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |