Sharing Data Relationships

Question

Hi,&nbsp;I have four tables which all have the same data column but I am having to create either multiple slicers or filters.&nbsp;E.g. [Country] or [Product]&nbsp;How can I share this relationship so that I only need to use one filter or sliver?&nbsp;Kind regards&nbsp;Dominic

crisyan · Answer

Create dimension tables with all the (uniques) Countries/Products/etc you want to filter. Then make relationship between this Dim. Tables and your 4 other tables, and use the Dimension Tables' columns on the slicers.

Regards!

anonymous · Answer

Hi Cris,&nbsp;This seems like a great idea, but do you have a dummy's guide?&nbsp;How can I create a table with this data in?How can I create the relationships?&nbsp;Kind regardsDominic

anonymous · Answer

CrisYan&nbsp;I have created a new table with columns with th shared values in them. But I am struggling to connect this to all of the other tables (which all have at least one of the values in them).&nbsp;

v-jiascu-msft · Answer

Hi&nbsp;Anonymous,
&nbsp;
Is the table "UK Revenue" the new table you created? I would suggest you create one dimension a table like below. Finally, we can get all the unique values without blanks.
Table =
FILTER (
    DISTINCT (
        UNION (
            VALUES ( Fields[Line Code] ),
            VALUES ( 'Volume By Month'[Line Code] ),
            VALUES ( 'Sales By Country'[Line Code] ),
            VALUES ( 'EU Revenue'[Line Code] )
        )
    ),
    ISBLANK ( [Line Code] ) = FALSE ()
)

Best Regards,
Dale

anonymous · Answer

Hi&nbsp;v-jiascu-msft,&nbsp;I created the 'Fields' table in excel including columns of all the shared values to be the dimensions table.&nbsp;Is this not what I was meant to do?&nbsp;I need to connect all of the other tables you can see and can delete the 'Fields' table if this is not the best practice way to do it.&nbsp;Kind regards&nbsp;Dominic

Forum Discussion

Sharing Data Relationships

7 Replies

Related content

Share Fabric Data Agent

Relationship

Relationships

Relationship Issue

Creating relationships