In the picture is the matrix table I created from 3 different sources:

blue = samples, database DimFuelSamples[FuelSampleID]

orange = parameters, database DimFuelResultType[ResultTypeCode]

green = results, database Facts_Fuel_Data[ResultNumberValue]

I would like to multiply the value of parameter A-ar and BD-ar, and display it as new column in this matrix table. For all samples in the table.

I cannot access any of these databases via the query tool, this is locked by the admin and owner of the semantic model. Would be convenient to do these changes in the table view or in the query, but that's not possible.

Does anyone know how to solve this problem?