Ratio between count of individual rows and aggregated column

[ERAHUMO]

I have data 1 in following format:

Header	value
A	1
A	1
A	1
A	1
A	1
A	1
A	1
A	1
B	1
B	1
B	1
B	1
B	1
B	1
B	1
B	1
B	1
C	1
C	1
C	1
C	1
C	1
C	1
C	1
C	1
C	1
D	1
D	1
D	1
D	1
D	1
D	1
D	1
D	1

and data 2 in following format

Header	Count
A	10
B	20
C	20
D	10

I am expecting to create a table visual in power bi which will give me following output

header	data1_value	data2_count	final
A	8	10	0.8
B	9	20	0.45
C	9	20	0.8
D	8	10	0.45

Can you help me to write a DAX measure to achieve final column

[Dangar332]

Hi, @ERAHUMO 
@ERAHUMO 
try below
make two measure
juast adjust your table and column name

a1= COUNTX('data1','data1'[value])

and

countfinal = DIVIDE([a1],MAX('data2'[Count]))

plot table visual and put column and above measure  you get like below

OR 

you can make a new table 
just adjust your table and column name

Table 3 = 

ADDCOLUMNS(ALL('data2'[Header]),
     "data1",CALCULATE(COUNT('data1'[value])),
     "count",CALCULATE(MAX('data2'[Count])),
     "countfinal",
      DIVIDE(
        CALCULATE(
           COUNT('data1'[value])
        ),
        CALCULATE(
          MAX('data2'[Count])
        )
    )
)