Forum Discussion
Userelationship not working between fact tables
Hello, 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...
PaulOlding
Solution Sage
Solution SageThe direction of the relationship between RESERVA_INVESTIMENTO and WALLET_OPERACOES is the reason you get the same value for Measure in every row of your visual. WALLET_OPERACOES doesn't filter RESERVA_INVESTIMENTO so you get the total amount of SUM('RESERVA_INVESTIMENTO'[VALUE]).
As you say, you're using RESERVA_INVESTIMENTO as a dimension for WALLET_OPERACOES, but then your measure is summing an amount on the dimension table.
You could potentially set the relationship direction to Both, but be careful as this can cause problems.