I've got the following scheme, where the tables RESERVA_INVESTIMENTO and WALLET_OPERACOES are both fact tables. However, it is possible to use RESERVA as a dimension table for WALLET.
The relationship is inactive because it causes ambiguity between the relationships marked with a cross.
But when I use a formula like this, for example:
I get a report like this:
How can I make this work?