Related values from 2 tables

[kizofilax]

Hello, I have 2 tables


IS
[TABLE="width: 500"]
<tbody>[TR]
[TD]Week[/TD]
[TD]Units[/TD]
[/TR]
[TR]
[TD]9/20[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]9/27[/TD]
[TD]2000[/TD]
[/TR]
</tbody>[/TABLE]

Cases[TABLE="width: 500"]
<tbody>[TR]
[TD]Week[/TD]
[TD]Cases[/TD]
[/TR]
[TR]
[TD]9/20[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]9/20[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]9/27[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]9/27[/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]


What I need to get is

[TABLE="width: 500"]
<tbody>[TR]
[TD]Week[/TD]
[TD]Ratio[/TD]
[/TR]
[TR]
[TD]9/20[/TD]
[TD]=600/1000[/TD]
[/TR]
[TR]
[TD]9/27[/TD]
[TD]=112/2000[/TD]
[/TR]
</tbody>[/TABLE]

The tables are already linked by a relationship using Week and I am trying to get that Ratio measure, any help with this?

Thanks

 

[JavierGuillen]

To create a ratio, put the Week column from the IS table in the pivot table row lables, and then create a new measure with the following definition:

CALCULATE( SUM( 'Cases'[Cases] ) ) / SUM( 'IS'[Units] )

 

[kizofilax]

To create a ratio, put the Week column from the IS table in the pivot table row lables, and then create a new measure with the following definition:

CALCULATE( SUM( 'Cases'[Cases] ) ) / SUM( 'IS'[Units] )

Thanks Javier, the issue with this is that it works if for the "x" axis I use the dates from the table IS but if I use the axis from the Cases column it doesn't, it gives me the correct sum for Cases for for Sum IS it gives me the total sum (not the sum per date)

And I need to use the Cases because I have several fields in that table that I need to use as slicers

Thanks

 

[JavierGuillen]

In that case, use the following expression instead:

CALCULATE( SUM( 'Cases'[Cases] ) ) / CALCULATE( SUM( 'IS'[Units] ), 'Cases')

 

[kizofilax]

In that case, use the following expression instead:

CALCULATE( SUM( 'Cases'[Cases] ) ) / CALCULATE( SUM( 'IS'[Units] ), 'Cases')

Thank you! This worked =)