Forum Discussion

BIanon's avatar
BIanon
Icon for Helper V rankHelper V
3 years ago

Activating inactive relationship / virtual relationship versus active relationship

Hello Community, Please consider the following relationships between these tables: And then consider then following DAX measure: COUNTROWS( DISTINCT( UNION( ...
Need Help
tt_and's avatar
tt_and
Icon for Advocate I rankAdvocate I
3 years ago

Hi. Sorry for not giving you a direct answer for the problem you are facing. I would instead highly recommend you to think differently about modelling. Either by merging all the products into one table using an extra column for "Product type" with values "1,2,3" or at least to move the category to a column in each product table. This way you can have a direct relation to all items between product and fact. If you have same ID for products in the different tables, making a column with surrogate key will give you unique IDs.
E.g: Product 1450 in table 1 and product 1450 in table 2 will have the value 1.1450 and 2.1450 in a ProductSK column.

  • BIanon's avatar
    BIanon
    Icon for Helper V rankHelper V
    3 years ago

    Hello,

    This example is just a small part of a large model. While I appreciate that you are trying to help, it is not applicable in this situation and your assumptions about the contents and use of the tables are wrong.

    This setup is created to enable a very specific type of comparative analytics that is commonly done within my data domain which PBI inherently has a hard time producing.

    Thanks. 🙂