How to divide a matrix cell by another matrix cell (Refer Screenshots below)

[Anonymous]

How do i divide the highlighted values of both the matrix table mentioned above in Power bi (2 different data sources are used for both tables) ?
Desired Result = 1180/1180 = 1

[Anonymous]

Hi @Anonymous ,

If you just want to calculate the sum table1 / sum table2 of Apple and D001? How about others?

Measure = 
var _t1=CALCULATE(SUM(Table1[Sales]),FILTER('Table1',[Brand Name]="Apple" && [Type]="D001"))
var _t2=CALCULATE(SUM(Table2[Sales]),FILTER('Table2',[Brand Name]="Apple" && [Type]="D001"))
return DIVIDE(_t1,_t2)

Measure for All = 
var _t2= CALCULATE(SUM(Table2[Sales]),FILTER('Table2',[Brand Name]=MAX('Table1'[Brand Name]) && [Type]=MAX('Table1'[Type])))
return DIVIDE(SUM(Table1[Sales]),_t2)

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , You need to have common dimensions Like brand name and department, date etc.

Then you divide measure from two table across common dimension

divide([Table Measure1], [Table Measure2])