link matrices

Hi  Anonymous ,

You can try to use Measure instead

I created some data:

Form a matrix:

Matrix A: Shows the value of [amount].

Matrix B: Shows the values of [rand].

Custom rule to display one column of Group=A&&amount and one column of Group=B&&rand in matrix A

Here are the steps you can follow：

1. Create measure.

A = MAX('Table'[amount])

Divide =
var _A=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[Group]="A"&&'Table'[Date]=MAX('Table'[Date])))
var _B=CALCULATE(SUM('Table'[rand]),FILTER(ALL('Table'),'Table'[Group]="B"&&'Table'[Date]=MAX('Table'[Date])))
return
DIVIDE(_A,_B)

2. Result:

Best Regards,

Liu Yang

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