Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sharing Data Relationships

Hi,   I have four tables which all have the same data column but I am having to create either multiple slicers or filters.   E.g. [Country] or [Product]   How can I share this relationship so t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Cris,

 

This seems like a great idea, but do you have a dummy's guide?

 

  • How can I create a table with this data in?
  • How can I create the relationships?

 

Kind regards


Dominic

Anonymous's avatar
Anonymous
Not applicable
8 years ago

CrisYan 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).

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-jiascu-msft,

       

      I created the 'Fields' table in excel including columns of all the shared values to be the dimensions table.

       

      Is this not what I was meant to do?

       

      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.

       

      Kind regards

       

      Dominic

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Dominic,

         

        As far as I know, one dimension table only contains one field. For example, Date table, Product table. We don't integrate these two tables together. Please refer to the snapshot below. It could be easy to establish relationships and control the result.

        Sharing_Data_Relationships

         

         

        Best Regards,

        Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Dale,

       

      Is there any update on my reply?

       

      Kind regards

       

      Dominic