Divide two columns from different tables

[dididing2001]

Hello everyone, currently I have two tables: table 1 and table 2 in Power BI

Table 1:

Date	Column A
01/01	120
02/01	34
03/01	90
04/01	109

Table 2:

Date	Column B
01/01	200
02/01	103
03/01	270
04/01	300

These tables are made in Power BI after I dragged two fields for each one.

For table 1, they are the "Date" column and column A (which is the count of "True" values for each day).

Date	Column C
01/01	True
01/01	False
01/01	True
02/01	True
03/01	True
03/01	True
04/01	True
04/01	False
04/01	False

Table 2 is made by counting the number of clicks for each day

What I want to do is: Column A divided by Column B (A/B for short) for each day and I will use that result to draw a graph. What can I do to achieve this?

Thanks for your help!

[NidhiBhusari]

Hi @dididing2001 ,

You can use measure 

Measure = DIVIDE(SUM('Table A'[Column A]),SUM('Table B'[Column B]))

[ryan_mayu · Accepted solution]

@dididing2001 

you can create a date table and create relationships with table 1 and table 2

Then create a measure

Measure = 
VAR _1=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[ColumnC]=TRUE()))
VAR _2=sum(Table2[click])
return _1/_2

pls see the attachment below

[dididing2001]

@ryan_mayu Thanks a lot for your help! Your method works like a charm for me!

[ryan_mayu]

you are welcome

[dididing2001]

@ryan_mayu Unfortunately, after checking the result, I'm afraid that the division didn't work well. I attached an image and my file below for your reference.

The conversion rate on 01/11/2019 is 0.7, which is 412/590. Meanwhile, what I want is the result of 412/2198. I cannot figure out the problem in this calculation. 

[ryan_mayu]

@dididing2001 

you need to imporve the data model, since the relationship between date table and two fact tables are inactive. I have deleted all the rest relationships. you can re-create the relationship. However, I still think you can simplify the data model.

pls see the attachment below.

[dididing2001]

The conversion rate works now. Your advice helps me a lot when it comes to data modelling. Thanks a lot!

[ryan_mayu]

you are welcome