The graph is not taking values from different files although relationship is created between file

[dodiyal]

Dear Team, I am having one issue in the power bi dashboard.

i have 2 files from which i wish to take the values and 3rd file is the relationsip between the first to file to connect the relationship.

But when i add the values in graph only 1 file values are showing and 2nd file value is not adding. can you help.

The file is like this.

Table 3  (the relationship file)

Product name

cycle

motorcycle

table 1

Product name   Purchased  Qty

cycle                     Yes             1

Motorcycle           No              1

Table 2

Product name    Purchased     Qty

motorcycle            yes             1

cycle                      No              1

so like this table 3 is the relationship file which connect both tables but when i add matrix graph like in row product name and in column purchased and value Qty then only either table 1 shows correctly or table 2 shows correctly but both are not showing at once.

Can you help

[v-lid-msft]

Hi  @dodiyal ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @dodiyal ,

We can use union function to append two tables as a fact table to meet your requirement:

Or we can create a dim table if you have more than two purchased record:

PurchasedDim = Distinct(Union(Distinct('table 1'[Purchased]),Distinct('Table 2'[Purchased])))

By the way, PBIX file as attached.

Best regards,

[parry2k]

@dodiyal can you make sure in Matrix , you are product name from table 3 and then it should work. And I assume you have one to many relationship from Table 3 to Table 1 and Table 2 with cross filter direction to single.

Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com Would appreciate Kudos 🙂 if my solution helped.