parseJson function can extract values from a JSON object or from a JSON array using path expressions. However, when working with JSON arrays, parseJson allows extraction only by a static index (e.g., the first array element using “$.convertedValue”). It currently does not support dynamic filtering by an inner key (such as extracting the element where toCurrency equals a parameter value) within a single calculated field.
In SPICE datasets, you may use parseJson only during data preparation, not in analysis-level calculated fields. For Direct Query datasets, you can use parseJson in both data preparation and in analysis calculated fields.
Please refer to the below community posts this might be helpful for you.