SVG Bar Chart within a table

Hi, from searching on the internet i found this brilliant code for adding a barchart into a standard table.

However, i can see that ChartScale is hardcoded (at 10,000), however all of my values in the table vastly differ and are independent of each other, therefore a fixed scale doesn't work.

How can i adapt the code below so that the Chart Scale is relative to the Maximum value for each row ('Area|Attribute') in the table. Apologies in advance, i'm a complete DAX novice.

Dynamic Chart = 
var BaseURL = "https://chart.googleapis.com/chart?"
var ChartType = "cht=bvs"
var ChartScale = "&chds=0,10000"
var ChartSize = "&chs=150x150"
var SeriesColour = "&chco=000000"
var ChartData = "&chd=t:" & CONCATENATEX('D - Current Year Data By Week (for Trend)','D - Current Year Data By Week (for Trend)'[zValue (week) as Measure], ",", 'D - Current Year Data By Week (for Trend)'[Reporting Thursday])
return IF(HASONEVALUE('D - Current Year Data By Week (for Trend)'[Key1: Area|Attribute]), BaseURL & ChartType & ChartScale & ChartSize & SeriesColour & ChartData)

Thanks

Stu