A measure that calculates the ratio of the number of packages to the production volume in a month

[ewelinag17]

Dear
I have two tables. One contains the dates and sizes of the product packages.
The second includes production dates and volumes.
They are database-linked by` date.
I need a graph that shows the package capacity on the "x" axis and the calculated ratio of the number of packages to the production volume on the "y" axis.
An example date below:

Do you know How to do it?
Thank you in advance for your help.
best regards

[ewelinag17]

@Anonymous @amitchandak @Greg_Deckler 

I'll simplify it a bit, because if I find out how to do this part, I can handle the rest.
I have two tables at the entrance.

I connect them with each other in the database using the "data" column.
In the output, I want to get a graph that was created on the basis of the table below.

There will be a year and month filter for the chart.

I can count the rows, but I use 4 measures and the graph doesn't come out. Can You help me?  Can it be done with one measure?

[Greg_Deckler · Accepted solution]

@ewelinag17 - You should be able to do something like this:

Measure =
  VAR __Count = COUNTROWS('Table1')
  VAR __Sum = SUMX(RELATEDTABLE('Table2'),[production volume])
RETURN
  DIVIDE(__Sum,__Count,0)

[Anonymous]

Is this model in imported mode, direct query or composite mode?

[amitchandak]

@ewelinag17 , I do not see any relation between package and production volume or date and date.

The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.

[Greg_Deckler]

@ewelinag17 - What do you mean by "package capacity" ? Can you post the data as text and the expected output from your sample data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.