Forum Discussion
USERELATIONSHIP
Hi admin_xlsior,
To be honest, your model needs to be optimized. Usually, the two dimensions should be independent.
1. About the ambiguity error, please refer to /desktop-create-and-manage-relationships#adjusting-cross-filter-direction-for-a-complex-set-of-tables-and-relationships for an answer.
2. Can you adjust the two tables in the source?
3. If it's possible to merge the two tables?
4. Can you share a sample? Please mask the sensitive parts.
Best Regards,
Hi,
Thank you for the response.
I'm not sure I can merge it, each table each table has it purpose. And I understand why you are saying need to optimized, especially if you looking at my ResourceCompany Table, and I open for an advice. However just need to inform that these tables is getting directly from OLTP / Transaction database and it is the way they built it.
And also we using Direct Query for the fetching method, so understand there might be some function limitation inside Power BI when we create measures or column.
To make it clear here is some picture to describe more clear :
Hope it is clear out.
Thanks,
Hi admin_xlsior,
Actually, you don't need to establish a relationship between Resource and Company. Why? If you want to analyze the Resouce and the Company, the Resource table has everything. You don't need to filter the Resource table from the Company table.
Finally, you have slicers from Company and Resouce to analyze the SalesFact table. For example, if you select BGR from the Company table and select Matt from the Resource table, the result is empty.
Please give it a try anyway.
Best Regards,