I am having dataset created. here i need to create new relationship between two tables. Inbetween these two tables there is a common column but i cannot create realtionship make the relation ship active. Getting cardiinality issues asking to remove other relationships to active this relationship. but i required those relations ships as well. What is need to do here.
You need to create a new dimension table with unique values convering the range of values for the common field in both tables. You then create a one-to-mamny relationship between the field in the new dimension table and the corresponding fields in each fact table. Use the dimension field in measures, filters, slicers and visuals.
Did I answer your question? Mark my post as a solution! In doing so, you are also helping me. Thank you!