How to return filtered sum number?

[bluetronics]

Hello

It would be appreiciated if someone can help me to get the filtered number.

There are 2 tables.

BI Desktop shows

I would like to get volume by  each region and divide the revenue of each region by volume of each volume.

Thanks in advance.

[Ashish_Mathur · Accepted solution]

Hi,

To your visual, drag Region from the Region table.

[bluetronics]

Thank you! it works.

[Ashish_Mathur]

You are welcome.

[DaleH]

"Cross filter direction" should be set to "Both" for both relationships to "Region".

[bluetronics]

It does not work. Pls. see the screenshot below: