the first C in "C$#,##0.##" is a reserved letter in the string function AS uses (VarTokenizeFormatString ) indicating the input is of a calendar format, correct way of setting currency is escaping it like: "\C$#,##0.##", fixed pbix file attached.
And below is a download link of the attached pbix file from pg: