Sales and target table how to link ?

[Anonymous]

Hi All

some one told me there should not be more then 1 link from one table to another table.

below is my data model, which have 4 link , it is okay ? 

[Icey]

Hi @Anonymous ,

Just like what @Anonymous mentioned, you can create 4 relationships between your Sales table and Target table. But only one relationship could be active.

To my knowledge, there is no need to establish so many relationships. It only needs to have a relationship to join the two tables together.

And for your tables, it is suggested to create relationships like so:

'Sales table'[Date] <-> 'Master Calendar'[Date] <-> 'Target table'[Date]

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Anonymous]

Hi Icey & Nikhi

Thank you very much for comment on my post , i have read about active and in-active relationship , i know in-active relationship is refer to sales order date and ship date . but i don't know how to set it as in-active.

Hope you can look at my PBI file , and share with me how to link the sales and target and calendar table ?

https://www.dropbox.com/sh/39wicbv0s06601n/AABTPEdsxof2co-e6RGnfDxKa?dl=0

Paul Yeo

[Icey · Accepted solution]

Hi @Anonymous ,

How about just creating one Source & Group table instead of one Source table and one Group table?

Source & Group =
DISTINCT (
    UNION (
        SUMMARIZE ( SALES, SALES[SOURCE], SALES[GROUP_] ),
        SUMMARIZE ( TARGET, TARGET[SOURCE], TARGET[GROUP_] )
    )
)

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Anonymous]

Hi Sir

Wow you are good , this is what i look for.

My data model very neat now.

Thank you 

Paul

[Anonymous]

@Anonymous There can be multiple relationships between two tables, however only one can remain active and others would be inactive.

There can be some scenerio, where we need to use our inactive relationships, so we can use them by using a function in DAX called- USERELATIONSHIP.

Take a look over thia https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive