Filter a report using query string parameters in the URL - not working due to &

[evano_oruvan]

This is my column name and value below.

ASSET_NAME

mats&service

Below is the dax code i use to get data from table and create a link to filter the my page, but it wont work when value(mats&service) in column(ASSET_NAME) has & in it, the link gets terminated at & like this 
https:/app.powerbi.com/?filter/somerandomtextand%20andthesemats
and the filter wont work, can someone help me escape this & so that value is accepted and filtered in my page,

RawData =
MAX ('Raw data'[Raw Data])&"?filter=Table/ASSET_NAME eq"&" '"
& MAX ( CurrentData[ASSET_NAME] )&"' and Table/LEVEL1 eq"&" '"
& MAX ( CurrentData[LEVEL])&"' and Table/DOS_NO eq"&" ' "
& MAX ( CurrentData[RULE_NO] )&" ' "

[evano_oruvan · Accepted solution]

Solution:

SUBSTITUTE( MAX ( CurrentData[ASSET_NAME] ),"&","%26").

[amitchandak]

@evano_oruvan , Are you trying something like this

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters