Forum Discussion
2 relationships between 2 fact tables
Hi. I need 2 relationships between 2 tables. (Sales Table, Budget Table) One Relationship is to connect the customer nr. The other is to connect the dates. I can activate only one relations...
u can't activate link between dates and Budged because u should use only one way to filtering tables
for example, filter Sales cube 2 way dates->sales cube and dates->budget->customer->Sales cube
use one direction link between customer and Budget tables
or use dax function USERELATIONSHIP() when u create a measure
ps sorry for my eng
petrovnikitamai
Resolver V
Resolver Vin pivot tables in report use column Customer from Customer table, not from Budget or Sales
thx alot. It works now as intended. now one more question:
If I want to use another dimesion from the sales table, for example customer group, it won't slice the budget.
do I have to make a new table with this dimensions and connect it to the customer table or how can I do that best?