Calculate Ratio between 2 columns from 2 tables

[Nissa23]

Hi,

I'd like to calculate a ratio between two mesures that are in different tables. Here is an example of what are my data

Column1Table1 & Colum1Table2   are a simple MESURES : Calculate(SUM(Column1Table1)), Calculate(SUM(Column1Table2))

Localisation            Colum1Table1       Colum1Table2             Ratio Wanted                             

A	1
B	141	18715	141/18715	0,75%
C	122	26737	122/26737	0,16%
D	198	21382
E	69	12637
F	299	10485
Total	830	89956

I've created a mesure like : DIVIDE(Colum1Table1 ,Colum1Table2) but the results are wrong.

Can anyone help.

Thanks

[Anonymous]

Hi @Nissa23 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[Nissa23]

Thanks for your answer. I've already resolved the issue.